private void Page_Load(object sender, System.EventArgs e)
{
if ( ! IsPostBack )
{
SqlConnection con = new SqlConnection(
“Data Source=localhost;Initial Catalog=northwind;” +
“Integrated Security=false;User id=YourUser;Password=YourPassword” );

SqlCommand selectCmd = new SqlCommand(“Ten Most Expensive Products”, con );
selectCmd.CommandType = CommandType.StoredProcedure;

SqlDataAdapter da = new SqlDataAdapter( selectCmd ) ;

DataSet results = new DataSet();
da.Fill ( results, “Products” );

DataGrid1.DataSource = results;
DataGrid1.DataMember = “Products”;
DataGrid1.DataBind();
}