請問有關ADO .Net開檔的問題

ADO.NET

有新評論時通知我

作者

主題: 請問有關ADO .Net開檔的問題

請問有關ADO .Net開檔的問題
發表時間: Friday, July 14, 2006 5:28 PM (台)

tmp_user = Me.txt_username.Text

Dim dbconn_string As String = "database = finance;server = com-sqldata;trusted_connection = yes"
        Dim select_string As String = "select * from log_info where loginname =" & tmp_user
        'Dim select_string As String = "select * from log_info"
        Dim conn As New System.Data.SqlClient.SqlConnection(dbconn_string)

conn.Close()
conn.Open()

Dim dbadapter As New SqlDataAdapter()

        Dim cmdSelect As New SqlClient.SqlCommand()
        cmdSelect.CommandText = select_string
        cmdSelect.Connection = conn

dbadapter.SelectCommand = cmdSelect

        Dim dbdataset As New System.Data.DataSet()
        dbadapter.SelectCommand = cmdSelect
        dbadapter.Fill(dbdataset)
    End Sub

程式碼如上,執行的時候會出現"無效的資料行名稱:admin"

admin是我在txt_username.Text輸入的值

可是如果把sql字串改為select loginname from log_info就沒這個問題

可以請教各位高手可以告訴我錯在那嗎?謝謝!!

回覆:

Author Thread:

tequilak

請問有關ADO .Net開檔的問題
Posted: Monday, July 17, 2006 11:24 AM (台)

我縮小問題點,想請教

Dim select_string As String = "select loginname from log_info where loginname = 'admin'"

Dim select_string As String = "select loginname from log_info where loginname = " & textbox1.text

這兩個sql語法在VB .Net裡有什麼不同嗎(textbox1.text我輸入admin)

為什麼第一個寫法會過,第二個寫法就會出現"無效的資料行名稱:admin"
我想破頭了,請各位高手幫我看一下,謝謝!!

tequilak

請問有關ADO .Net開檔的問題
Posted: Monday, July 17, 2006 2:28 PM (台)

我知道那裡錯了.只是單純的語法錯誤.