1.

Can Datareader Hold Data From Multiple Tables?

Answer»

data reader can hold data from MULTIPLE tables and datareader can hold more than ONE table.

string QUERY="select * from employee; select * from STUDENT";
sqlcommand cmd=new sqlcommand(query, connection);
sqldatareader dr=cmd.executeReader();
if(dr.hasrows)
{
dr.read();
gridview1.DataSource=dr;
gridview1.Databind();
if(dr.nextresult)
{
gridview2.datasource=dr;
gridview2.databind();
}
}
dr.colse();
connection.close();

data reader can hold data from multiple tables and datareader can hold more than one table.


Discussion

No Comment Found

Related InterviewSolutions