Can dataReader hold data from multiple tables?
Submitted by: Administratordata 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();
Submitted by: Administrator
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();
Submitted by: Administrator
Read Online ADO.NET Job Interview Questions And Answers
Top ADO.NET Questions
☺ | Which one of the following objects is a high-level abstraction of the Connection and Command objects in ADO.NET? |
☺ | Difference between SqlCommand and SqlCommandBuilder? |
☺ | Can dataReader hold data from multiple tables? |
☺ | What provider ADO.net use by default? |
☺ | What is different between SqlCommand object and Command Behavior Object? |
Top Dot Net Technologies Categories
☺ | MSF Interview Questions. |
☺ | .Net Architecture Interview Questions. |
☺ | ASP.Net MVC Interview Questions. |
☺ | Entity Framework Interview Questions. |
☺ | C# (Sharp) Programming Language Interview Questions. |