VB.NET - Firebird ODBC adapter fill datagrid.

See more:

VB

DataGridView

ODBC

Firebird

I am developing a Windows Forms application with firebird DB using ODBC driver to connect to the database and should fill a DataGrid with the results of a query; This is the code but I do not work in ..... what am I wrong?

Private Sub Form1_Shown(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Shown

Dim cn As OdbcConnection

cn = New OdbcConnection("dsn=PHOENIXDB;uid=SYSDBA;pwd=masterkey;")

Dim mystring As String = "Select * from SSN_REGIONE"

Dim cmd As OdbcCommand = New OdbcCommand(mystring)

Dim daSSNregione As New OdbcDataAdapter

Dim dsSSNregione As New DataSet

cn.Open()

Try

daSSNregione.SelectCommand = cmd

daSSNregione.Fill(dsSSNregione)

DataGridViewX1.DataSource = dsSSNregione

Catch ex As Exception

MsgBox("Error: " & ex.Source & ": " & ex.Message, MsgBoxStyle.OkOnly, "Connection Error !!")

End Try

cn.Close()

End Sub