How do you get data from database in to gridview?

Answer 1

//define SQLDB connection string

string strSQLconnection = "Data Source=dbServer;Initial Catalog=DBNAME;Integrated Security=True;uname=username;password=pwd";

//initialize sqlconnection from the connection string.

SqlConnection sqlConnection = new SqlConnection(strSQLconnection);

//initialize the query to be fired.

SqlCommand sqlCommand = new SqlCommand("select * from table1", sqlConnection);

//open sql connection

sqlConnection.Open();

//Fire the query and open the reader to store the results

SqlDataReader reader = sqlCommand.ExecuteReader();

//define the datsource for the gridview

GridView1.DataSource = reader;

//bind the gridview. this will populate the gridview

GridView1.DataBind();