Follow this example for loading a data from database to datagrid or gridview
First you need to connect to the database using instance of SqlConnection class... im doing it in C#
-
SqlConnection sqlcon=new SqlConnection("enter the query string here");
-
Now you need to use the SqlDataAdapter object
-
SqlDataAdapter ada=new SqlDataAdapter("select string",sqlCon);
-
now that you have loaded the data from the databse in the adapter
you now need to have the dataset to fill the data retrieved
-
DataSet dSet=new DataSet();
-
Now use the adapter's fill method to fill the data to the dataset
Now assign the dataset to the gridview or datagrid
-
GridView1.DataSource=dSet;
-
and the nyou need to bind the datagrid to the control
