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

---
Posted using Wimdows.net NntpNews Component -

Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

[Tobbe]

Use the Table as the datasource instead of the Dataset.

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

/Tobbe

"MarkCFC" wrote:

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

---
Posted using Wimdows.net NntpNews Component -

Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.