Comments by Kamran Khan

Kamran Khan 13-Jul-13 11:50am View

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

Kamran Khan 12-Jul-13 7:02am View

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

Kamran Khan 12-Jul-13 6:08am View

Deleted

sir
thanks for giving me a solution
plz tell me also
how can i confirm that user exists in database (registered) while the executenonquery does not return any value
i did not use this before and dont know how to use it now
how to use condition of confirmation of user by if structure as in my code

Comments by Kamran Khan (Top 3 by date)