Anyone know how to Bulk Insert to SQL from string Array with comma delimited columns in Array
<p>I have a string array in C3 that gets populate with Yahoo Historical data that has data in the array like this..</p>

<pre><code>string url = string.Format("http://ichart.yahoo.com/table.csv?s={0}&amp;a=2&amp;b=1&amp;c=2010&amp;d={1}&amp;e={2}&amp;f={3}&amp;g=&amp;ignore=.csv",
    SymbolSelect, CurrentMonth, Today, CurrentYear); 
WebClient web = new WebClient();
string data = web.DownloadString(url);
string[] rows = data.Split("\n".ToCharArray());
</code></pre>

<p>Array rows--->> Date,Open,Low,close,Volume,AdjClose</p>

<p>The array rows will have each row as stated above with 6 columns of data per row. I have no idea how to insert that into a sql table? I know how to insert to a sql table, but not like this from this array structure. Anyone know how to insert every single row of thousands with this structure??</p>

<p>Thanks in Advance!</p>
