private void btnUpdate_record_Click(object sender, EventArgs e)
{
try
{
con = new SqlConnection(cs.DBcon);
con.Open();
string cb = "update Event set Eventname='" + txtEventName.Text + "', StartingDate='" + dtpStartingDate.Text + "' , StartingTime='" + dtpStartingTime.Text + "' , EndingDate='" + dtpEndingDate.Text + "' , EndingTime ='" + dtpEndingTime.Text + "' , ManagedBy='" + textBox1.Text + "' , Activities='" + txtActivities.Text + "' where EventID='" + txtEventID.Text + "' ";
cmd = new SqlCommand(cb);
cmd.Connection = con;
cmd.ExecuteReader();
frmEventRecords frm = new frmEventRecords();
frm.GetData();
MessageBox.Show("Successfully updated", "Event Details", MessageBoxButtons.OK, MessageBoxIcon.Information);
st1 = lblUser.Text;
st2 = "Updated the Event'" + txtEventName.Text + "'";
cf.LogFunc(st1, System.DateTime.Now, st2);
btnUpdate_record.Enabled = false;
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void button2_Click(object sender, EventArgs e)
{
this.Hide();
frmEventRecords form2 = new frmEventRecords();
form2.lblUser.Text = lblUser.Text;
form2.lblUserType.Text = lblUserType.Text;
form2.Show();
}