string[] strngSep1 = str.Split(';');
ds = new DataSet();
int counter =1;
foreach (string strng in strngSep1)
{
SqlDataAdapter adap = new SqlDataAdapter("Select Fecha, Valor from datos where " + strng + " and NumEstacion = @StationID and Fecha between @start_DateTime and @end_DateTime", con2);
adap.SelectCommand.Parameters.Add("@start_DateTime", start_query_date);
adap.SelectCommand.Parameters.Add("@end_DateTime", end_query_date);
adap.SelectCommand.Parameters.Add("@StationID", station_var);
adap.Fill(ds, "Table" + counter.ToString());
counter++;
~ Remember To Mark The Post(s) That Helped You As The ANSWER ~
Shakti Singh Tanwar
.Net Trainer (MCP,MCAD.net,MCSD.net,MCTS,MCPD.net[web])
Marked as answer by v-ambily on May 19, 2011 09:30 AM
Shakti Singh...
Star
10870 Points
1827 Posts
Re: values from one dataadapter to multiple tables in a dataset through foreach loop
May 19, 2011 08:46 AM|LINK
string[] strngSep1 = str.Split(';'); ds = new DataSet(); int counter =1; foreach (string strng in strngSep1) { SqlDataAdapter adap = new SqlDataAdapter("Select Fecha, Valor from datos where " + strng + " and NumEstacion = @StationID and Fecha between @start_DateTime and @end_DateTime", con2); adap.SelectCommand.Parameters.Add("@start_DateTime", start_query_date); adap.SelectCommand.Parameters.Add("@end_DateTime", end_query_date); adap.SelectCommand.Parameters.Add("@StationID", station_var); adap.Fill(ds, "Table" + counter.ToString()); counter++;Shakti Singh Tanwar
.Net Trainer (MCP,MCAD.net,MCSD.net,MCTS,MCPD.net[web])