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 PersonIDLastNameFirstName 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 tablenamecon); 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