private void btnAddUser_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(@"Server=.\SQLEXPRESS;Database=school;Integrated Security=true");
conn.Open();
string query = "";
query = "INSERT INTO [employee] (name,designation,address,contact) VALUES('" + textName.Text + "','" + textDesig.Text + "','" + textAddress.Text + "'," + textContact.Text + ")";
SqlCommand cmd = new SqlCommand(query, conn);
try
{
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
if (textName.Text != null && textDesig.Text != null && textAddress.Text != null && textDesig.Text != null)
{
MessageBox.Show("Successfully added!!!", "Succesfull");
}
else
{
MessageBox.Show("Please Fill All The Field!!!", "Incomplete");
}
}
else
{
MessageBox.Show("error!!!", "Error");
}
}
catch { MessageBox.Show("Please Fillup Correctly!!", "Error"); }
conn.Close();
h.RefreshEployeeTable();
}
private void btnAddUser_Click(object sender, EventArgs e)
{
conn.Open();
SqlCommand cmd = new SqlCommand("update [employee] set name = '" + textName.Text + "',designation = '" + textDesig.Text + "',address = '" + textAddress.Text + "',contact ='" + textContact.Text + "' where e_id = " + eid + "", conn);
try
{
int result = cmd.ExecuteNonQuery();
if (result > 0)
{
MessageBox.Show("Update Success!!!", "Succesfull");
}
}
catch (Exception ex) { MessageBox.Show(ex.Message.ToString(), "Error"); }
conn.Close();
h.RefreshEployeeTable();
}