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(); } }