Click here to Skip to main content
15,349,320 members
Home / Discussions / C#
   

C#

 
GeneralC# to Mysql Login code Error Pin
N Mohamed rafi21-Mar-22 16:34
MemberN Mohamed rafi21-Mar-22 16:34 
SuggestionRe: C# to Mysql Login code Error Pin
Richard Deeming21-Mar-22 22:26
mveRichard Deeming21-Mar-22 22:26 
AnswerRe: C# to Mysql Login code Error Pin
Richard Deeming21-Mar-22 22:28
mveRichard Deeming21-Mar-22 22:28 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi21-Mar-22 22:33
MemberN Mohamed rafi21-Mar-22 22:33 
GeneralRe: C# to Mysql Login code Error Pin
Richard Deeming21-Mar-22 22:38
mveRichard Deeming21-Mar-22 22:38 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi21-Mar-22 22:43
MemberN Mohamed rafi21-Mar-22 22:43 
GeneralRe: C# to Mysql Login code Error Pin
Richard Deeming21-Mar-22 23:03
mveRichard Deeming21-Mar-22 23:03 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi21-Mar-22 23:20
MemberN Mohamed rafi21-Mar-22 23:20 
Sir, Now i have passed three parameters but it shows login successfull with wrong userid password also sir

if (textBox9.Text != "" && textBox10.Text != "")
{
string connectionString;
MySqlConnection cnn;
connectionString = @"Data Source=localhost;Initial Catalog=testDB;User ID=root;Password=mysql";
cnn = new MySqlConnection(connectionString);
string id = textBox9.Text;
string password = textBox10.Text;
string loginid = "";
textBox9.Text = "";
textBox10.Text = "";
string query = "select * from login where userid=@userid and password=@password and loginid=@loginid";
using (MySqlCommand cmd = new MySqlCommand(query))
{
cmd.Parameters.AddWithValue("@userid", id);
cmd.Parameters.AddWithValue("@password", password);
cmd.Parameters.AddWithValue("@loginid", loginid);
cmd.Connection = cnn;
cnn.Open();
cmd.ExecuteNonQuery();
DialogResult dr = MessageBox.Show("Are you sure to Login now?", "Confirmation", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
MessageBox.Show("Login Successfully");
cnn.Close();
this.Hide();
Form2 f2 = new Form2();
f2.ShowDialog();
}
else if (dr == DialogResult.No)
{
MessageBox.Show("Please Enter Correct Login details");
}
}
}
else
{
MessageBox.Show("Please Enter details to Login");
}
}
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 
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 

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.