private void updatebtn_Click(object sender, EventArgs e)
{
if (CloSearchText.Text == "")
{
MessageBox.Show("select a clo or type clo name");
return;
}
DateTime date = DateTime.Now;
SqlConnection con = new SqlConnection(conString);
string query = "update Clo set DateUpdated='" + date + "', Name ='" + CloSearchText.Text + "' where Id = '" + CloId + "'";
SqlCommand cmd = new SqlCommand(query, con);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
CloSearchText.Clear();
clo_load();
MessageBox.Show(CloSearchText.Text + " has been updated");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
private void cloCreatebtn_Click(object sender, EventArgs e)
{
DateTime date = System.DateTime.Now;
SqlConnection con = new SqlConnection(conString);
string query = "insert into dbo.Clo(Name,DateCreated,DateUpdated) values ('" + this.CloSearchText.Text + "','" + date + "', '" + date + "')";
SqlCommand cmd = new SqlCommand(query, con);
try
{
con.Open();
cmd.ExecuteNonQuery();
con.Close();
CloSearchText.Clear();
clo_load();
MessageBox.Show("succesfully created");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
