«

hi friend

I am developing web application in .NET using c#. I encounter a problem in binding the results to the datagrid. I have a storeprocedure that produce 2 results set. I need to read the results and bind it in a datagrid control. But i am able to bind only one result set eventhough i am using the datareader.next result(); Can any one of you help me? My code follows her

SqlCommand cmd1 = new SqlCommand("Testpaper_DHistory",conn)
cmd1.CommandType=System.Data.CommandType.StoredPro cedure
SqlParameter myparam = cmd1.Parameters.Add(new SqlParameter("@nric",SqlDbType.VarChar,20))
myparam.Value = Session["userid"].ToString()
SqlDataReader myreader = cmd1.ExecuteReader()
d

Grid1.DataSource=myreader
Grid1.DataBind()

while (myreader.NextResult())
myreader.Close()
conn.Close()

Even I tried Grid1.Datasource = cmd1.ExecuteReader(); It is also not working.

you should join the two tables
use SqlDataAdapter.Fill in to a DataSet ds first
DataTable table1=ds.Tables[0];
DataTable table2=ds.Tables[1];
foreach(DataRow row in table2.Rows)
{
table1.ImportRow(row);
}
Grid1.DataSource=table1.DefaultView;
Grid1.DataBind();

"jasmine" <> дÈëÓʼþ
news:9F10BDD9-CD92-46D0-8675-...
> hi friends
>
> I am developing web application in .NET using c#. I encounter a problem in
binding the results to the datagrid. I have a storeprocedure that produce 2
results set. I need to read the results and bind it in a datagrid control.
But i am able to bind only one result set eventhough i am using the
datareader.next result(); Can any one of you help me? My code follows here
>
> SqlCommand cmd1 = new SqlCommand("Testpaper_DHistory",conn);
> cmd1.CommandType=System.Data.CommandType.StoredPro cedure;
> SqlParameter myparam = cmd1.Parameters.Add(new
SqlParameter("@nric",SqlDbType.VarChar,20));
> myparam.Value = Session["userid"].ToString();
> SqlDataReader myreader = cmd1.ExecuteReader();
> do
> {
> Grid1.DataSource=myreader;
> Grid1.DataBind();
> }
> while (myreader.NextResult());
> myreader.Close();
> conn.Close();
>
>
> Even I tried Grid1.Datasource = cmd1.ExecuteReader(); It is also not
working.
>