Question

asp.net连接mysql连接字符串究竟应该怎么写？我的代码如下，但是却连接不是数据库，求高手指点下

Private Sub bind()
Dim conn As MySQLConnection= New MySQLConnection(New MySQLConnectionString("localhost", "paintingnet", "root", "root", 3306).AsString)
Try
If conn.State = ConnectionState.Closed Then
conn.Open()
End If
Dim commn As New MySQLCommand("set names gb2312", conn)
commn.ExecuteNonQuery()

Dim Data As New DataTable
Dim s As String = "SELECT * FROM auction"
Dim da As New MySQLDataAdapter(s, conn)
da.Fill(Data)
gvIndex.DataSource = Data
gvIndex.DataBind()
Catch ex As MySQLDriverCS.MySQLException
Dim str As String = ex.Message
Response.Write("<script>alert('连接数据失败,请联系管理员!')</script>")
Return
End Try
End Sub

Answer 1

都.net了为什么还要用ASP的写法列？？

c#提供专门的SqlConnection类型，实例化之后OPEN。

SET好几个参数比如COMMAND之后就可以返回一个SQLREADER类。

直接.read()方法就可以开始读了