How To get data from database into datatable ?

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();
    }
}
 

Hi santosh,

try this :