Click here to Skip to main content
15,562,669 members
Home / Discussions / C#
   

C#

 
GeneralC# to Mysql Login code Error Pin
N Mohamed rafi21-Mar-22 17:34
N Mohamed rafi21-Mar-22 17:34 
SuggestionRe: C# to Mysql Login code Error Pin
Richard Deeming21-Mar-22 23:26
mveRichard Deeming21-Mar-22 23:26 
AnswerRe: C# to Mysql Login code Error Pin
Richard Deeming21-Mar-22 23:28
mveRichard Deeming21-Mar-22 23:28 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi21-Mar-22 23:33
N Mohamed rafi21-Mar-22 23:33 
GeneralRe: C# to Mysql Login code Error Pin
Richard Deeming21-Mar-22 23:38
mveRichard Deeming21-Mar-22 23:38 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi21-Mar-22 23:43
N Mohamed rafi21-Mar-22 23:43 
GeneralRe: 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
N Mohamed rafi22-Mar-22 0:20
N Mohamed rafi22-Mar-22 0: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 Deeming22-Mar-22 0:25
mveRichard Deeming22-Mar-22 0:25 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi22-Mar-22 0:34
N Mohamed rafi22-Mar-22 0:34 
GeneralRe: C# to Mysql Login code Error Pin
Richard Deeming22-Mar-22 0:45
mveRichard Deeming22-Mar-22 0:45 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi22-Mar-22 0:37
N Mohamed rafi22-Mar-22 0:37 
GeneralRe: C# to Mysql Login code Error Pin
Richard Deeming22-Mar-22 0:44
mveRichard Deeming22-Mar-22 0:44 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi22-Mar-22 0:47
N Mohamed rafi22-Mar-22 0:47 
RantRe: C# to Mysql Login code Error Pin
Richard Deeming22-Mar-22 1:03
mveRichard Deeming22-Mar-22 1:03 
GeneralRe: C# to Mysql Login code Error Pin
Richard MacCutchan22-Mar-22 1:47
mveRichard MacCutchan22-Mar-22 1:47 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi22-Mar-22 1:49
N Mohamed rafi22-Mar-22 1:49 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi22-Mar-22 1:51
N Mohamed rafi22-Mar-22 1:51 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi22-Mar-22 1:54
N Mohamed rafi22-Mar-22 1:54 
GeneralRe: C# to Mysql Login code Error Pin
Richard MacCutchan22-Mar-22 1:57
mveRichard MacCutchan22-Mar-22 1:57 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi22-Mar-22 2:06
N Mohamed rafi22-Mar-22 2:06 
GeneralRe: C# to Mysql Login code Error Pin
Richard MacCutchan22-Mar-22 2:09
mveRichard MacCutchan22-Mar-22 2:09 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi22-Mar-22 2:24
N Mohamed rafi22-Mar-22 2:24 
GeneralRe: C# to Mysql Login code Error Pin
Richard MacCutchan22-Mar-22 2:28
mveRichard MacCutchan22-Mar-22 2:28 
GeneralRe: C# to Mysql Login code Error Pin
N Mohamed rafi22-Mar-22 2:37
N Mohamed rafi22-Mar-22 2: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.