本文介绍了如何解决这个问题“值不能为空。参数名称: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&quot;的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-16 02:03
查看更多