Can a DataReader be used as a DataSource for a GridView.
If it is so how will you handle paging.
Answers were Sorted based on User's Feedback
Answer / rahul singhal
yes u can use data reader to fill gridview with while
function. and paging depends upon the datagrid property. if
u use custom paging there in no possibility with data
reader. u will have to use data table to fill data grid and
data table should be filled through data reader.
Is This Answer Correct ? | 9 Yes | 1 No |
Answer / karthikeyant
some changes made in the above code
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();
DataTable dataTable = new DataTable();
dataTable.Load(dr);
dr.Close();
_cmd.Dispose();
dataGridView2.DataSource = dataTable;
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
What you mean by filtering of data?
Diff B/W DataSet vs DataTable
Give an example of a .net application which connects to microsoft access database using ado.net classes.
What is DataRowCollection?
What is the difference in an abstract class and an interface?
Which keyword is used to accept variable number of parameters?
What is the key feature of ADO.NET compared to ADO ?
How do you update database through dataset?
Does entity framework use ado.net?
What connected data?
Describe the disconnected architecture of ADO.NET’s data access model.
What is typed dataset ?