Hi,
In my application ,iam using stored procedure.and that stored procedure return values from 2 tables
means 2 select queries.
my problem is ,i want to connect this with dataset.
i tried like this
using (SqlCommand cmd = new SqlCommand("Sp_selconductorTest", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@tourdate", tDate);
cmd.Parameters.AddWithValue("@busid", busid);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds1 = new DataSet();
DataSet ds2 = new DataSet();
da.Fill(ds1.Tables[0]);
da.Fill(ds2.Tables[1]);
}
this showing error.
if i try
da.Fill(ds1);
it displays first table values.
How to take value of second table?
Regards,
Baiju