Re: vs 2008 c++ access mysql database

[oz oz]

here is vb code. i am new for mysql :-)

Imports MySql.Data.MySqlClient
Imports System.Data
Partial Class _Default
Inherits System.Web.UI.Page
Dim conn As MySqlConnection
Dim da As MySqlDataAdapter
Dim ds As New DataSet

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

'connection string
conn = New MySqlConnection("server=localhost;uid=yourusername;pwd=yourpassword; database=test;")
conn.Open()

'Data adapter
da = New MySqlDataAdapter("select * from yourtableintestdatebase", conn)

'Dataset
da.Fill(ds, "yourtable")

'
GridView1.DataSource = ds.Tables("yourtable").DefaultView

GridView1.DataBind()


conn.Close()
End Sub
End Class