private void button1_Click(object sender, EventArgs e)
{
ValidateData();
usersModels um = new usersModels();
um.uid = Convert.ToInt32(userId.Text);
um.UName = UserName.Text;
um.Password = textBox3.Text;
um.add();
}
public void add(usersModels user)
{
try
{
string Query = "insert into users(UserId,UserName,Password) values('" + user.uid + "','" + user.UName + "','" + user.Password + "');";
MySqlCommand MyCommand2 = new MySqlCommand(Query, cnn);
MySqlDataReader MyReader2;
cnn.Open();
MyReader2 = MyCommand2.ExecuteReader();
MessageBox.Show("Save Data");
while (MyReader2.Read())
{
}
cnn.Close();
}
catch (Exception ex)
{
}
}
public void delete(usersModels user)
{
try
{
string Query = "delete from users where UserId='" + user.uid + "';";
;
MySqlCommand MyCommand2 = new MySqlCommand(Query, cnn);
MySqlDataReader MyReader2;
cnn.Open();
MyReader2 = MyCommand2.ExecuteReader();
MessageBox.Show("Data Deleted");
while (MyReader2.Read())
{
}
cnn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void update(usersModels user)
{
try
{
string Query = "update users set UserName='******',Password='******' where UserId='" + user.uid + "';";
MySqlCommand MyCommand2 = new MySqlCommand(Query, cnn);
MySqlDataReader MyReader2;
cnn.Open();
MyReader2 = MyCommand2.ExecuteReader();
MessageBox.Show("Data Updated");
while (MyReader2.Read())
{
}
cnn.Close();//Connection closed here
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}