private void button3_Click(object sender, EventArgs e)
{
var chartno = int.Parse(textBox1.Text);
var station = textBox2.Text;
var datedigitzed = dateTimePicker1.Value.ToString("yyyy/MM/dd");
int season = int.Parse(textBox4.Text);
var dateon = dateTimePicker2.Value.ToString("yyyy/MM/dd");
var dateoff = dateTimePicker3.Value.ToString("yyyy/MM/dd");
con_db save_chart = new con_db();
string sql = "UPDATE `charts` SET `st_code` = '" + station + "',`date_digitized` = '" + datedigitzed + "',`season` = '" + season + "',`date_on` = '" + dateon + "',`date_off` = '" + dateoff + "' WHERE `chart_number` = '" + chartno + "' LIMIT 1";
if (save_chart.Update(sql))
{
MessageBox.Show("Data Updated Successfully");
Dispose();
chartmngmnt newform = new chartmngmnt();
newform.ShowDialog();
}
else
{
MessageBox.Show("Failed to Update data");
}
}
private void pictureBox2_Click(object sender, EventArgs e)
{
Hide();
chartmngmnt newfrm = new chartmngmnt();
newfrm.ShowDialog();
Show();
}
