Interested to Buy Any Domain ? << Click Here >> for more details...
Can a DataReader be used as a DataSource for a GridView.
If it is so how will you handle paging.
- 3 Answers
- 10418 Views
- Directi, I also Faced
- E-Mail Answers
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 ole used for?
Define partial class?
How can we check that some changes have been made to dataset since it was loaded?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
What is linq and entity framework?
What provider ado.net use by default? Explain the role of data provider in ado.net?
What is oledb connection?
What does ado stand for?
What is ado object model?
What are the different ado.net namespaces?
What is the use of SqlCommandBuilder?
What is the difference between sqlcommand and sqldataadapter?
What are all the different authentication techniques used to connect to MS SQL Server?
How to aggregating data across related tables?
What is the difference between SqlCommand and SqlCommandBuilder?
