求助,連數據庫讀入的問題啊
大家看看程序,'後面的是在database中read用的
但不能用,一直有error,想文文怎麽回事?
注是去掉就能connect the database
但加上就不能用了
用的日文系同,有的字打不出,只能先在的秧子
Dim strconnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;"
strconnection += "Data Source=D:\vb\northwind.mdb"
data_src.Text = strconnection
' Dim strsql As String = "select firstname, lastname from enployees"
' Dim strresultsholder As String
Dim objconnection As New OleDbConnection(strconnection)
' Dim objcommand As New OleDbCommand(strsql, objconnection)
' Dim objdatareader As OleDbDataReader
Try
objconnection.Open()
con_open.Text = "connection opened successfully.<br>"
' objdatareader = objcommand.ExecuteReader()
' Do While objdatareader.Read() = True
' strresultsholder += objdatareader("firstname")
' strresultsholder += " "
' strresultsholder += objdatareader("lastname")
' strresultsholder += "<br>"
'Loop
' objdatareader.Close()
objconnection.Close()
con_close.Text = "connection closed.<br>"
' Response.Write(strresultsholder)
Catch ex As Exception
con_open.Text = "connection failed to open.<br>"
con_close.Text = e.ToString()
End Try