Fill data from database to DataGridView
Creat a form and a button on form.The name of button is "FILL".When you click on "FILL" the data form database "Northwind" is filled on dataGridview.
can you fix help me?
thanks!
The code of event when click button:
[code]
private void button1_Click(object sender, EventArgs e)
{
string ConnectionString = "Data Source = SUPERCOMPUTER" + "Integrated Security=SSPI"
+ "Initial Catalog=NorthwindDataSet";
SqlConnection connect = new SqlConnection();
connect.ConnectionString = ConnectionString;
string strSql = "SELECT CustomerID,ContactName,ContactTitle
FROM Customers";
SqlDataAdapter dad = new SqlDataAdapter(strSql, connect);
DataSet dat = new DataSet("Customers");
dad.Fill(dat,"Customers");
customersTableAdapter.Fill(northwindDataSet.Customers);
[/code]
}