车载gps价格:帮一把,谢谢,关于ASP.net连接数据库的问题
来源:百度文库 编辑:高考问答 时间:2024/07/03 09:35:39
给你一段代码,我写一个vb.net的程序时候用的
Sub LoadCommandList()
Dim objConn As New Odbc.OdbcConnection
Dim objCmd As New Odbc.OdbcCommand
Dim objDataReader As Odbc.OdbcDataReader
CommandList.Items.Clear()
objConn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};Dbq=" & Application.StartupPath & "\database.mdb"
Debug.Print(Application.StartupPath & "\database.mdb")
objConn.Open()'连接数据库
objCmd.Connection = objConn
objCmd.CommandText = "select * from Commands"
objDataReader = objCmd.ExecuteReader()'执行SQL语句
While objDataReader.Read()'读数据,以下和数据库连接无关
CommandList.Items.Add(objDataReader.GetString(0) & "," & objDataReader.GetString(1))
End While
objConn.Close()
End Sub
如果需要C#代码的话看这里
http://blog.sina.com.cn/u/54eca7b201000207