Program error, (picture), how should solve? For years, help!!!!!!-CodePudding

CodePudding user response:

This is a VB plate, plate is not VB.NET

, this should be a grammar you use wrong, error is the process of turning an object into a string failure,
Strcomp syntax format (string 1, 2, optional parameters), from here you can see, your RS1 is obviously a data set, rather than a string, so this wrong

CodePudding user response:

The

reference 1/f, don't understand, don't say ah response: ,

this is a VB plate not VB.NET plate , this should be a grammar you use wrong, error is the process of turning an object into a string failure,
Strcomp syntax format (string 1, 2, optional parameters), from here you can see, your RS1 is obviously a data set, rather than a string, so quote the wrong

Then how to compare them

CodePudding user response:

The

reference 1/f, don't understand, don't say ah response: ,

this is a VB plate not VB.NET plate , this should be a grammar you use wrong, error is the process of turning an object into a string failure,
Strcomp syntax format (string 1, 2, optional parameters), from here you can see, your RS1 is obviously a data set, rather than a string, so quote the wrong

How to change it?

CodePudding user response:

to see you this usage RS1 is supposed to be a data set?

CodePudding user response:

Rs1. Open the "select * from table name where username field='" & amp; The replace (textbox1. Text, "'", "" '") & amp;" '", conn, 1, 1
If rs1. Recordcount<> 1 then
Msgbox "incorrect username
"Elseif rs1. Fields (" password ") & lt;> Textbox2. Text then
Msgbox "password incorrect"
End the if

Probably together just let it be, if you are using VB.Net should consider using ADO.Net without ADO

CodePudding user response:

The

reference, on the third floor of the fifth floor response:

rs1. Open the "select * from table name where username field='" & amp; The replace (textbox1. Text, "'", "" '") & amp;" '", conn, 1, 1
If rs1. Recordcount<> 1 then
Msgbox "incorrect username
"Elseif rs1. Fields (" password ") & lt;> Textbox2. Text then
Msgbox "password incorrect"
End the if

Probably together just let it be, if you are using VB.Net should consider using ADO.Net without ADO

Thank you very much! Thank you so much for bosses.

CodePudding user response:

refer to 4th floor don't understand, don't say ah response:

to see you this usage RS1 is supposed to be a data set?

Yes rs1 a data set is so wrong