how to do solve this problem "Value cannot be null. Parameter name: dataTable"

Question

0.00/5 (No votes)

See more:

VB

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"

Posted 16-Feb-12 19:05pm

Ravi chandran from thanjavur

Add a Solution

Comments

Varun Sareen 17-Feb-12 2:01am

Are you initializing the datatable? Please provide some more clarity into it.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2012-02-17T04:21:00

Solution 1

If you're error pops up on the line da.Fill(dt) it's telling you that you didn't create a DataTable object. You're passing in Nothing instead of an instance of a DataTable.

You didn't provide the code that declared dt, so it's impossible to say for sure.

Perhaps you did this:

Dim dt As DataTable

instead of this:

Dim dt As New DataTable

Posted 17-Feb-12 4:21am

Dave Kreskowiak

Comments

Ravi chandran from thanjavur 17-Feb-12 22:01pm

thanks

Ravi chandran from thanjavur 17-Feb-12 22:08pm

i have created DataTable object. Again the Same error please help me.

Dave Kreskowiak 17-Feb-12 23:05pm

Again, you haven't shown us the ENTIRE code that is around the line where the error occurs nor have you told us on which line it occurs.

basurajkumbhar · Answer 2 · 2013-10-28T03:30:00

VB

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.......

udayams · Answer 3 · 2013-10-28T03:46:00

Solution 4

You are passing the string command to sqldataadapter. Insted of that you can pass the sqlcommand alone to it. And that execute non query is not needed. I think this will be your problem.

Posted 28-Oct-13 3:46am

udayams

Comments

Member 13258186 9-Jul-17 20:58pm

Using mail As New MailMessage
mail.From = New MailAddress("admissioncsabnic@gmail.com")
mail.To.Add(destination.Text$)
mail.Body = lblname.Text$
'If Not OpenFileDialog1.FileName = vbNullString Then
'Dim attach As New Attachment()
Dim attach As New System.Net.Mail.Attachment(profilepic1.ImageLocation)
'MyMailMessage.Attachments.Add(attchm)
mail.Attachments.Add(attach)
'End If
mail.Subject = lblname.Text$
mail.Priority = mail.Priority.Normal
Using SMTP As New SmtpClient
'SMTP.EnableSsl = True
'SMTP.Port = "587"
'SMTP.Host = "smtp.gmail.com"
'SMTP.Credentials = New Net.NetworkCredential("ujjawal.vermanu53@gmail.com", "bholenath1994")
'SMTP.Send(mail)

SMTP.Host = "smtp.gmail.com"
SMTP.EnableSsl = True
Dim NetworkCred As NetworkCredential = New NetworkCredential("admissioncsabnic@gmail.com", "sachin@6")
SMTP.UseDefaultCredentials = True
SMTP.Credentials = NetworkCred
SMTP.Port = 587
SMTP.Send(mail)
End Using
End Using

how to do solve this problem "Value cannot be null. Parameter name: dataTable"

3 solutions

Solution 1

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us