Can a DataReader be used as a DataSource for a GridView.
If it is so how will you handle paging.
Answer Posted / dinesh sharma
_cmd.Connection = CON; //_cmd is sqlCommand and
CON is Connection
_cmd.CommandText = "select
Book_Code,ISBN,Title_Of_book from Book_Master";
SqlDataReader dr = _cmd.ExecuteReader();
dts.Columns.Add("Book_Code");
dts.Columns.Add("ISBN");
dts.Columns.Add("Title_Of_book"); DataRow drs;
while (dr.Read())
{
drs = dts.NewRow();
drs[0] = dr[0].ToString();
drs[1] = dr[1].ToString();
drs[2] = dr[2].ToString();
dts.Rows.Add(drs);
Application.DoEvents();
}
dataGridView2.DataSource = dts;
dr.Close();
_cmd.Dispose();
Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is ado.net in mvc?
Explain the architecture of ado.net?
Do you use stored procedure in ado.net?
What is connection in ado.net?
Explain sqlconnection object?
What is difference in record set and dataset?
What is data adapter in ado.net with example?
What is Data view?
What is dbcontext and dbset in entity framework?
Explain what are acid properties?
What is data access pattern?
What is the namespaces being used to access oracle database?
What is sqlconnection and sqlcommand?
What is the full form of ado.net?
Which architecture does Datasets follow?