Tuesday, April 7, 2015

How to bind dataset to Gridview using C#

       Bind Dataset to gridview

 string connectionString = "server=ServerName;" + "integrated security=SSPI;" +     "database=DBNaame";
SqlConnection myConnection;
string strSelectStament = "SELECT * FROM AccountsTable";
SqlCommand myCommand;
DataSet myDataSet;
myConnection = new SqlConnection(connectionString);
myConnection.Open();
myCommand = new SqlCommandstrSelectStament,myConnection);
SqlDataAdapter mySQLDataAdapter;
myDataSet = new DataSet();
mySQLDataAdapter = new SqlDataAdapter(myCommand);
mySQLDataAdapter.Fill(myDataSet, "AccountsTable");
GridView1.DataSource = myDataSet;
GridView1.DataBind();

No comments:

Post a Comment