本文介绍了如何解决这个问题“值不能为空。参数名称:dataTable"的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
MY SQL TABLE,
Table name Login.
column Name Datatype
Username varchar(10)
Password nchar(10)
/* source code */
con.Open()
str = "select * from login where Username='" & UnameTextBox.Text & "' and Password='" & UPassword.Text & "' "
cmd = New SqlCommand(str, con)
da = New SqlDataAdapter(str, con)
da.Fill(dt)
If dt.Rows.Count <> 0 Then
Response.Redirect("SelectBranch.aspx")
Else
MsgBox("is not match")
cmd.ExecuteNonQuery()
End If
con.Close()
Run time:
Error message is "Value cannot be null. Parameter name: dataTable"
推荐答案
Dim dt As DataTable
而不是:
instead of this:
Dim dt As New DataTable
Dim str As String
str = "select * from login where Username='" & UnameTextBox.Text & "' and Password='" & UPassword.Text & "' "
Dim da As New SqlDataAdapter(str, con)
Dim ds As New DataSet
da.Fill(ds, "login")
if dt.rows.cont<>o then
Response.Redirect("SelectBranch.aspx")
Else
MsgBox("is not match")
cmd.ExecuteNonQuery()
End If
我希望这会对你有所帮助
也请给我答复会发生什么.......
I hope this will help for you
please also give me reply what happens.......
这篇关于如何解决这个问题“值不能为空。参数名称:dataTable"的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!