Hello

I'm using Visual Studio 2005 and Microsoft Access 2007 (database is saved in 2007 format).

The code which I have been using to display data in a DataGridView from a stored procedure in Microsoft Access comes from 'Beginning Visual Basic 2005 Databases'.

From what I have found my code works but no records are displayed in the DataGridView. The column headings are visible but the actual data is not. Running the query in Access displays two rows of data.

Any ideas as to why this is happening?
:(

Could you post some of the relevant code so we might see what you are doing?

-Peter
peterlanoie.blog

Hello Peter

Sorry, I should have included this originally.

  objConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0 ;Data Source=C:\MyDatabase.accdb;Persist Security Info=False;")


        'Initialize a new instance of the OleDbCommand class.
        objCommand = New OleDbCommand

        'Set command object properties.
        objCommand.CommandText = "qryMyAccessQuery"
        objCommand.CommandType = CommandType.StoredProcedure
        objCommand.Connection = objConnection

        'Initialize a new instance of the Adapter class.
        objDataAdapter = New OleDbDataAdapter

        'Initialize a new instance of the DataSet class.
        objDataSet = New DataSet

        'Set the SelectCommand for the DataAdapter.
        objDataAdapter.SelectCommand = objCommand

        'Populate the DataSet.
        objDataAdapter.Fill(objDataSet, "DataSet")

        Me.DataGridView.DataSource = objDataSet
        Me.DataGridView.DataMember = "DataSet"

Have you debugged this yet to see if objDataSet contains anything?

I'm not sure if you need to specify the DataMember in order to get the data to display. But I haven't done much windows forms apps so I can't say for sure.

-Peter
peterlanoie.blog

Hello Peter

I tried to determine if there was any data in the DataSet but wasn't sure of the best way to do this. (What is the right way to check if a DataSet contains data?)

So I changed the Command object to reference a table using the following code and the data is displayed as it should be.

      objConnection = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0 ;Data Source=C:\MyDatabase.accdb;Persist Security Info=False;")

        'Initialize a new instance of the OleDbCommand class.
        objCommand = New OleDbCommand

        'Set command object properties.
        objCommand.CommandText = "tblMyAccessTable"
        objCommand.CommandType = CommandType.TableDirect
        objCommand.Connection = objConnection

        'Initialize a new instance of the Adapter class.
        objDataAdapter = New OleDbDataAdapter

        'Initialize a new instance of the DataTable class.
        dt = New DataTable

        'Set the SelectCommand for the DataAdapter.
        objDataAdapter.SelectCommand = objCommand

        'Populate the DataTable.
        objDataAdapter.Fill(dt)

        Me.DataGridView.DataSource = dt

I must be missing a step in populating the data into a DataSet within my previous code. Any ideas as to what it might be?

The only difference I see is that you are querying a query versus a table. I haven't worked with Access in .NET so I can't provide you much help in that regard. However, I can't imagine they would be much different though.

-Peter
peterlanoie.blog