Can't Display Data in DataGrid

[Ed_P.]

Hello

I have a Windows Form that I am trying to use to display data in a DataGrid object from an Access Database. I have created an OleDbCommand Object (with the appropriate Connection string) to Select the appropriate data. I then use a OleDbDataAdapat er to Fill a DataSet object. My problem is that I can't seem to show the results of the query on my datagrid object. Here is Code

private void btnSearch_Click (object sender, System.EventArg s e

OleDbDataAdapte r dataAdapter = new OleDbDataAdapte r()
DataSet dataSet = new DataSet()

//Here is the OleDbCommand object that has already been initalized with appropriate OleDbConnection objec
this.selectCust omersCmd.Comman dText = "Select * From Customers"

dataAdapter.Sel ectCommand = this.selectCust omersCmd
dataAdapter.Fil l(dataSet, "Customers" )

//Show DataTable on DataGrid objec
this.dataGridOb ject.DataSource = dataSet.Tables["Customers"].DefaultView
}

[William Ryan eMVP]

Ed_P:

How many rows do you have? I'm guessing you aren't getting any back hence
it's not showing.
"Ed_P." <an*******@disc ussions.microso ft.com> wrote in message
news:E3******** *************** ***********@mic rosoft.com...

Hello,

I have a Windows Form that I am trying to use to display data in a DataGrid object from an Access Database. I have created an OleDbCommand
Object (with the appropriate Connection string) to Select the appropriate
data. I then use a OleDbDataAdapat er to Fill a DataSet object. My problem
is that I can't seem to show the results of the query on my datagrid object.
Here is Code:
private void btnSearch_Click (object sender, System.EventArg s e)
{
OleDbDataAdapte r dataAdapter = new OleDbDataAdapte r();
DataSet dataSet = new DataSet();

//Here is the OleDbCommand object that has already been initalized with appropriate OleDbConnection object this.selectCust omersCmd.Comman dText = "Select * From Customers";

dataAdapter.Sel ectCommand = this.selectCust omersCmd;
dataAdapter.Fil l(dataSet, "Customers" );

//Show DataTable on DataGrid object
this.dataGridOb ject.DataSource = dataSet.Tables["Customers"].DefaultView;
}

[Ed_P.]

I get about 15 rows, it's a small test application...a nd I do get rows back...I have used a foreach loop to go thru the datatable and I do get the data, I have included the code for the foreach look below for your reference...I don't seem to know where to go with this so any info you can provide will be greatly appreicated

foreach(DataRow row in this.dataSet.Ta bles["Customers"].Rows

MessageBox.Show (row["CustomerNa me"].ToString())
}

[William Ryan eMVP]

Ed_P:

Is this a web or winforms app? if it's ASP.NET hen you need to call
DataGrid.DataBi nd(); after you set the datasource, if it's winforms, then
that's surprising problem indeed. If it is, let me know and I'll see what I
can come up with.

Cheers,

Bill
"Ed_P." <an*******@disc ussions.microso ft.com> wrote in message
news:11******** *************** ***********@mic rosoft.com...

I get about 15 rows, it's a small test application...a nd I do get rows back...I have used a foreach loop to go thru the datatable and I do get the
data, I have included the code for the foreach look below for your
reference...I don't seem to know where to go with this so any info you can
provide will be greatly appreicated!
foreach(DataRow row in this.dataSet.Ta bles["Customers"].Rows)
{
MessageBox.Show (row["CustomerNa me"].ToString());
}