Click here to Skip to main content
15,359,445 members
Home / Discussions / C#
   

C#

 
GeneralRe: C# to Mysql Login code Error Pin
Richard Deeming21-Mar-22 23:25
mveRichard Deeming21-Mar-22 23:25 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi21-Mar-22 23:34
MemberN Mohamed rafi21-Mar-22 23:34 
GeneralRe: C# to Mysql Login code Error Pin
Richard Deeming21-Mar-22 23:45
mveRichard Deeming21-Mar-22 23:45 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi21-Mar-22 23:37
MemberN Mohamed rafi21-Mar-22 23:37 
GeneralRe: C# to Mysql Login code Error Pin
Richard Deeming21-Mar-22 23:44
mveRichard Deeming21-Mar-22 23:44 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi21-Mar-22 23:47
MemberN Mohamed rafi21-Mar-22 23:47 
RantRe: C# to Mysql Login code Error Pin
Richard Deeming22-Mar-22 0:03
mveRichard Deeming22-Mar-22 0:03 
GeneralRe: C# to Mysql Login code Error Pin
Richard MacCutchan22-Mar-22 0:47
mveRichard MacCutchan22-Mar-22 0:47 
How many times do I need to say it: Do not post a success message when you have not checked the result of your Database query.
This is the way you should do it:
C++
cnn.Open();
int result = cmd.ExecuteNonQuery(); // always capture the result
cnn.Close();
if (result == 1)
{
    MessageBox.Show("Login was successful");
}
else
{
    MessageBox.Show("The entered details were not correct");
}

Also, why do you need two ids (userid and loginid)? You should only need a single id and a password.
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi22-Mar-22 0:49
MemberN Mohamed rafi22-Mar-22 0:49 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi22-Mar-22 0:51
MemberN Mohamed rafi22-Mar-22 0:51 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi22-Mar-22 0:54
MemberN Mohamed rafi22-Mar-22 0:54 
GeneralRe: C# to Mysql Login code Error Pin
Richard MacCutchan22-Mar-22 0:57
mveRichard MacCutchan22-Mar-22 0:57 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi22-Mar-22 1:06
MemberN Mohamed rafi22-Mar-22 1:06 
GeneralRe: C# to Mysql Login code Error Pin
Richard MacCutchan22-Mar-22 1:09
mveRichard MacCutchan22-Mar-22 1:09 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi22-Mar-22 1:24
MemberN Mohamed rafi22-Mar-22 1:24 
GeneralRe: C# to Mysql Login code Error Pin
Richard MacCutchan22-Mar-22 1:28
mveRichard MacCutchan22-Mar-22 1:28 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi22-Mar-22 1:37
MemberN Mohamed rafi22-Mar-22 1:37 
GeneralRe: C# to Mysql Login code Error Pin
Dave Kreskowiak22-Mar-22 2:57
mveDave Kreskowiak22-Mar-22 2:57 
GeneralRe: C# to Mysql Login code Error Pin
Richard MacCutchan21-Mar-22 22:46
mveRichard MacCutchan21-Mar-22 22:46 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi21-Mar-22 22:49
MemberN Mohamed rafi21-Mar-22 22:49 
GeneralRe: C# to Mysql Login code Error Pin
Richard MacCutchan21-Mar-22 23:10
mveRichard MacCutchan21-Mar-22 23:10 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi21-Mar-22 23:26
MemberN Mohamed rafi21-Mar-22 23:26 
GeneralRe: C# to Mysql Login code Error Pin
Richard MacCutchan21-Mar-22 23:42
mveRichard MacCutchan21-Mar-22 23:42 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi21-Mar-22 23:49
MemberN Mohamed rafi21-Mar-22 23:49 
GeneralRe: C# to Mysql Login code Error Pin
Richard MacCutchan21-Mar-22 23:55
mveRichard MacCutchan21-Mar-22 23:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.