Hello.
I'm trying to bind a griidview with some MySQL data. I'm using Visual WebDeveloper 2005 Express.
What I do is, create a general function to handle the connections and all that kind of stuf, then, I send to the gridview.DataSource the function, wich will return a dataset.
What happens is that i an't see any data in the gridview.
Can anybody help me?
Thanks in advance.
Code:Public Class acessos Public num_registos As Integer Public VectForm(2048) As Boolean Public User As String = "root" Public Password As String = "admin" Public servidor As String = "localhost" Public BD As String = "radioportal" Public Function AbreDataSet(ByVal strSQL As String, ByVal Tabela As String) As Data.DataSet Dim ds As Data.DataSet Dim DataAdapt As Data.Odbc.OdbcDataAdapter Dim ConnString As String = _ "driver={MySQL ODBC 3.51 Driver};server=" & servidor & _ ";uid=" & User & _ ";pwd=" & Password & _ " ;database=" & BD Dim conn As New Data.Odbc.OdbcConnection(ConnString) Try DataAdapt = New Data.Odbc.OdbcDataAdapter(strSQL, ConnString) ds = New Data.DataSet conn.Open() DataAdapt.Fill(ds, Tabela) num_registos = ds.Tables(0).Rows.Count.ToString() Return ds Catch exx As Exception 'MsgBox(exx.Message & Chr(13), MsgBoxStyle.Information) End Try 'Return ds End Function '------------------------------------------ ' '------------------------------------------ Dim acc As New acessos Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim strSQL As String = "Select * from utilizadores" Me.GridView1.DataSource = acc.AbreDataSet(strSQL, "utilizadores") 'definir o DataSet a abrir Me.GridView1.DataMember = "utilizadores" End Sub




Reply With Quote