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 executequery return?
How to read data with the sqldatareader ?
Why do we need ado.net?
What is sqlconnection and sqlcommand?
What are the 3 major types of connection objects in ado.net?
What is the difference between oledb sql server and oledbdotnet provider?
How can we check that some changes have been made to dataset since it was loaded?
Does executenonquery return a value?
can we create synonymn in ms access,sql server,my sql if so explain me with example
What is Data Provider?
What is executequery?
Which control of the BindingNavigator returns the current position within the data source?
What are two types of transaction supported by ado.net?
Which method is used to sort the data in ADO.Net?
What does ado stand for in ado.net?