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 |
How to read data with the sqldatareader ?
What are the Features of a dataset
How to retrieve the user id which is provided while windows authentication?
What are all the different methods under sqlcommand?
What is a non query?
Is it possible to edit data in Repeater control?
What is ole in excel?
What is a dynaset in access?
What is difference between ado and other data object?
In how many ways we can retrieve table records count? How to find the count of records in a dataset?
What are the steps to connect to a database?
What are the main differences between classic ado and ado.net?