Dynamically Populating a Gridview with SQL Data Adapter

This snippet shows you a simple way to dynamically populate a GridView. Your SQL Select statement will determine which columns you want displayed in your GridView.

//declare two variables - one for the connection string and the other for the dataset
private String cnstr;
private DataSet ds;

protected void Page_Load(object sender, EventArgs e)
{
// Setup Connection string
cnstr= "server=type in IP address;user=type in database user;password=type in database password;"
+ "database=type in database name;";

// Create a new Sql Connection
SqlConnection cn = new SqlConnection(cnstr);

//Create the DataSet
ds = new DataSet("ds");

//Create a new Sql Data Adapter
//In your SQL Select statement, only select the columns you want to be displayed
//If you use the select all (*) it will obviously display all the columns
SqlDataAdapter da= new SqlDataAdapter( "Your Select Statement" , cn);
// Fill the Data Adapter
da.Fill(ds);

//Set the Datasource for the GridView equal to the DataSet
GridView1.DataSource = ds;
//Bind your Data
GridView1.DataBind();
}

*Quick Note: Don't forget to add 'using System.Data.SqlClient;' to the top of the code behind page.

In your .aspx page add the following code in between the body tags. Click on the image to view full size .

If you have any questions or there are discrepancies in the code please feel free to leave a comment and I will try to answer/fix them as soon as I can.