How To get data from database into datatable ?

Question

how we get data from database and showing it into a gridview?

Bhabani Prasad · Answer

private void BindGridView() { // Get the connection string from Web.config. // When we use Using statement, // we don't need to explicitly dispose the object in the code, // the using statement takes care of it. using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLServer2005DBConnectionString"].ToString())) { // Create a DataSet object. DataSet dsPerson = new DataSet(); // Create a SELECT query. string strSelectCmd = "SELECT PersonID,LastName,FirstName FROM Person"; // Create a SqlDataAdapter object // SqlDataAdapter represents a set of data commands and a // database connection that are used to fill the DataSet and // update a SQL Server database. SqlDataAdapter da = new SqlDataAdapter(strSelectCmd, conn); // Open the connection conn.Open(); // Fill the DataTable named "Person" in DataSet with the rows // returned by the query.new n da.Fill(dsPerson, "Person"); // Get the DataView from Person DataTable. DataView dvPerson = dsPerson.Tables["Person"].DefaultView; // Bind the GridView control. gvPerson.DataSource = dvPerson; gvPerson.DataBind(); } }

Anupam Singh · Answer

Hi santosh, try this : SqlConnection con = new SqlConnection("initial catalog=yourdb;integrated security=true;data source=.");//use your connection settings here connection con.Open(); SqlCommand cmd = new SqlCommand("select * from tablename",con); cmd.CommandType = CommandType.Text; SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); hope it helps