Click here to Skip to main content
15,346,893 members
Home / Discussions / C#
   

C#

 
GeneralRe: how sort datgridview or listview like windows explorer Pin
Le@rner22-Mar-22 1:20
MemberLe@rner22-Mar-22 1:20 
GeneralRe: how sort datgridview or listview like windows explorer Pin
Dave Kreskowiak22-Mar-22 1:50
mveDave Kreskowiak22-Mar-22 1:50 
AnswerRe: how sort datgridview or listview like windows explorer Pin
Richard Deeming21-Mar-22 22:32
mveRichard Deeming21-Mar-22 22:32 
GeneralRe: how sort datgridview or listview like windows explorer Pin
Le@rner22-Mar-22 2:00
MemberLe@rner22-Mar-22 2:00 
GeneralRe: how sort datgridview or listview like windows explorer Pin
Le@rner28-Mar-22 1:36
MemberLe@rner28-Mar-22 1:36 
GeneralRe: how sort datgridview or listview like windows explorer Pin
Richard Deeming28-Mar-22 21:45
mveRichard Deeming28-Mar-22 21:45 
AnswerRe: how sort datgridview or listview like windows explorer Pin
RobertSF26-Mar-22 13:32
professionalRobertSF26-Mar-22 13:32 
GeneralC# to Mysql Login code Error Pin
N Mohamed rafi21-Mar-22 16:34
MemberN Mohamed rafi21-Mar-22 16:34 
Sir, I have studied and tried to put login page but it shows code error please tell me the correction sir
It shows error: System.InvalidOperationException: 'The connection is already and also code error
private void button14_Click(object sender, EventArgs e)
{
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);
cnn.Open();
string id = textBox9.Text;
string password = textBox10.Text;
textBox9.Text = "";
textBox10.Text = "";
string query = "select * from login where userid=@userid,password=@password,confirmpassword=@confirmpassword where loginid=@loginid is same";
//string query = "update employee set employee_name=@employee_name,employee_salary=@employee_salary where employee_id=@employee_id";
using (MySqlCommand cmd = new MySqlCommand(query))
{
cmd.Parameters.AddWithValue("@userid", id);
//cmd.Parameters.AddWithValue("@employee_id", Convert.ToInt32(id));
cmd.Parameters.AddWithValue("@password", password);
//cmd.Parameters.AddWithValue("@confirmpassword", confirmpassword);
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");
}
}
}
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 
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 

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.