Datagrid for Windows Forms does not automatically drop down

[MarkCFC]

My project consists of one form and one standard microsoft datagrid.

In code and not by binding, I create a sqlconnection, sqlAdapter and dataset. When the form is displayed I have to click on the datagrid to display the result of my query. I cannot get the datagrid to automatically show the result on the form. In other words you need to click the grid twice to display the results.

Is this how the grid works? Surely not. Can somebody help?

My code is?

In the Form_Load event place the following:

SqlConnection mySqlConnection = new SqlConnection(data source=<servername>;persist security info=False;initial catalog=Northwind");

SqlDataAdapter mySqlAdapter = new SqlDataAdapter("SELECT * FROM EMPLOYEES",mySqlConnection);

DataSet myDataSet = new DataSet();
mySqlAdapter.Fill(myDataSet,"EMPLOYEES");
dataGrid1.DataSource = myDataSet;


thanks
Mark

 

[Guest]

Use the Table as the datasource instead of the Dataset.

dataGrid1.DataSource = MyDataSet.Tables["EMPLOYEES"]

/Tobbe