HOW TO FILL GRID VIEW WITH OUT USING SQLDATASOURCE AND
PROGRAMING?
Answer Posted / manumole
SqlConnection conn = new SqlConnection("Data
Source=MYSERVER;Initial Catalog=Northwind;User
Id=sa;Password=sa;");
conn.Open();
DataTable dt=new DataTable();
SqlDataAdapter da = new SqlDataAdapter("select
* from Employees", conn);
da.Fill(dt);
testGV.DataSource = dt;
| Is This Answer Correct ? | 15 Yes | 8 No |
Post New Answer View All Answers
What does executereader return?
What are the steps you will take to improve performance?
Explain advantages of ado.net?
Explain the dataadapter class in ado.net?
How do you update database through dataset?
What is a sqldataadapter?
What is different between sqlcommand object and command behavior object?
What are the advantages of using datalist?
What are the different execute methods of Ado.Net?
What are the rules to implement connection pooling?
What are the 3 major types of connection objects in ado.net?
Explain the various objects in dataset.
How to store data in memory?
What is ole in excel?
Explain how to call the sql commands asynchronously in ado.net version 2.0?