QUOTE(dushi @ 25 Apr, 2008 - 01:51 PM)
This one is for access db. I want to know what i have to change to use mysql db. or is there a site that can show me!
CODE
<script runat = "server">
Sub Page_Load_click()
Dim dbconn As OleDbConnection
Dim sql As String
Dim dbcomm As OleDbCommand
Dim dbread As OleDbDataReader
dbconn = New OleDbConnection(" Provider= Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Owner\Desktop\db1.mdb;User Id=;Password=; ")
dbconn.Open()
sql = "Select * From Name"
dbcomm = New OleDbCommand(sql, dbconn)
dbread = dbcomm.ExecuteReader()
Gridview1.Datasource = dbread
Gridview1.DataBind()
dbread.Close()
dbconn.Close()
End Sub
</script>
Use this connectin string in the place of y'u connection string
========================
"Data Source=localhost;Initial Catalog=yooffer;Integrated Security=false;Pooling=False;user=user_name;password=password"
===================
25 Apr, 2008 - 01:51 PM
tags when posting code.
|