conversion datatype error

Question

0.00/5 (No votes)

See more:

hi
i am new and beginner in programming
i am using Visual Studio ultimate and sql server express edition
i write a code to search phone number from the database
but i am getting error of " too large or too small value for int 32" or "conversion from string to integer is not valid"
in my database the column type is nvarchar(11) and including 0 total digits are 11
i also tried convert.toint32 and convert.toint64 but error still there.
my code is

VB

Dim cmd As New SqlClient.SqlCommand
            Dim DaLogin As New SqlClient.SqlDataAdapter
            Dim ds As New DataSet
            cmd.CommandText = "SELECT PhoneNo from [Users] WHERE PhoneNo = '" & Convert.ToInt64(txtloginuser.Text.Trim) & "'"
            Con.Open()
            cmd.Connection = Con
            DaLogin.SelectCommand = cmd
            DaLogin.Fill(ds, "0")
            Dim count = ds.Tables(0).Rows.Count
            'check weither data exist in database or not 
            If count > 0 Then
                MsgBox("User found now open the conenction", "Valid User", vbOKOnly + vbInformation)
                btnconnect.Enabled = True
            Else
                MsgBox("User not registered in database. try again or create a new account", "Invalid Phone No", vbOKOnly + vbCritical)
                txtloginuser.Text = Focused()

            End If

plz check and tell me the solution for removing this error

Posted 11-Jul-13 14:34pm

Kamran Khan

Add a Solution

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)

berrymaria · Answer 1 · 2013-07-11T15:13:00

Solution 1

VB

Dim query As String = "SELECT PhoneNo from [Users] WHERE PhoneNo = @LoginUser"
   Using conn As New System.Data.SqlClient.SqlConnection("Connection String")
     Dim cmd As New System.Data.SqlClient.SqlCommand(query, conn)
     cmd.Parameters.AddWithValue("@LoginUser", SqlDbType.NVarChar).Value = txtloginuser.Text
     conn.Open()
     cmd.ExecuteNonQuery()

Posted 11-Jul-13 15:13pm

berrymaria

Comments

Kamran Khan 12-Jul-13 7:02am

Now i used the code as u provided
but the error is still there

Dim query As String = "SELECT PhoneNo from [Users] WHERE PhoneNo = @LoginUser"
'Dim cmd As New System.Data.SqlClient.SqlCommand(query, Con)
'cmd.Parameters.AddWithValue("@LoginUser", SqlDbType.NVarChar).Value = txtloginuser.Text
'Con.Open()

'Dim rowaffected As Integer
'rowaffected = cmd.ExecuteNonQuery()
'If rowaffected = 1 Then
' MsgBox("User found now open the conenction", "Valid User", vbOKOnly + vbInformation)
' btnconnect.Enabled = True
'Else
' MsgBox("User not registered in database. try again or create a new account", "Phone No", vbOKOnly + vbCritical)
' txtloginuser.Text = Focused()
'End If

berrymaria 12-Jul-13 20:33pm

Could you try to change

cmd.Parameters.AddWithValue("@LoginUser", SqlDbType.NVarChar).Value = txtloginuser.Text

to

Dim Name As String = txtloginuser.Text
cmd.Parameters.Add("@UserName", SqlDbType.NVarChar).Value = Name;

Kamran Khan 13-Jul-13 11:50am

i also use this
and also tried datareader in seperate code
but the error still there
sir
plz chek the datatype is correct for retrieving a phoneno from database
signup code is working fine
datatype is nvarchar(11) with not null condition

_Asif_ · Answer 2 · 2013-07-11T17:39:00

Solution 2

I don't see a reason why you are converting txtLoginId into int32 if the underlying datatype is nvarchar.

this should work as well.

C#

cmd.CommandText = "SELECT PhoneNo from [Users] WHERE PhoneNo = '" txtloginuser.Text.Trim & "'"

Posted 11-Jul-13 17:39pm

_Asif_

Kamran Khan · Answer 3 · 2013-07-11T23:32:00

Solution 3

thanks for providing ur experience
i have tried this syed asif iqbal but same error arrises
i am trying the chimcham solution
thanks

Posted 11-Jul-13 23:32pm

Kamran Khan