[RESOLVED] [2005] newbie - Bind DataGrid with data (Access DB)

[RS_Arm]

Hi.
I want to make a function to bind DataGrid with Access Data tables.
This is my code, which is not working.
What am I doing wrong?

Public sConnString As String = _
                    "Driver={Microsoft Access Driver (*.mdb)};" & _
                    "Dbq=D:\VBProjects\GestaoProjecto\BaseDados\GesProj.mdb;" & _
                    "Uid=Admin;" & _
                    "Pwd="


    Function OpenDataSet(ByVal strSQL As String) As DataSet
        Dim ds As DataSet
        Dim DataAdapt As Odbc.OdbcDataAdapter


        DataAdapt = New Odbc.OdbcDataAdapter(strSQL, sConnString)
        ds = New DataSet()
        Return ds

    End Function

On my form, I've got this code to bind my datagrid.

  Private Sub FormArtigos_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        CarregaArtigos()
    End Sub

    Private Sub CarregaArtigos()
        Me.DataGridView1.DataSource = OpenDataSet("Select * from Artigos")
    End Sub

Thank you.

[SharkC382]

Well, 2 things need to happen. You need to open the database to get to the data, and you need to use the dataadapter to "fill" the dataset. Also, since a dataset can have multiple tables, you'll want to name your table, and use that name as the .DataMember value on your DataGridView.

 
    Function OpenDataSet(ByVal strSQL As String) As DataSet
        Dim ds As DataSet
        Dim DataAdapt As Odbc.OdbcDataAdapter

        Dim conn As New Odbc.OdbcConnection(sConnString)
        

        DataAdapt = New Odbc.OdbcDataAdapter(strSQL, sConnString)
        ds = New DataSet()


        conn.open
        DataAdapt.Fill(ds, "MyTable")

        Return ds

    End Function

And then after you set .DataSource, you need to set the .DataMember.

Me.DataGridView1.DataMember = "MyTable"


Regards

[jmcilhinney]

A DataSet is pointless if all it contains is one DataTable. Just have your method create and return a DataTable instead. You can then assign that to the DataSource property and not worry about the DataMember.

[RS_Arm]

Thank you. That really helped me.