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 fetch the last inserted record in a particular table?
10 Answers CarrizalSoft Technologies, Microsoft,
Explain how do you connect to sql server database without using sqlclient?
Explain acid properties?
What is a string variable?
What is the purpose of using adodb?
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
How do you merge 2 datasets into the third dataset in a simple manner?
What is difference between ado.net and asp net?
What is the difference between connected and disconnected environment?
What are the different layers of ado.net?
What is the difference between linq and ado.net?
what is trigger?
8 Answers Microsoft, Precept Technology,