private void SecretaryMessage_Load(object sender, EventArgs e)
{
SqlConnection conDataBase = new SqlConnection(constring);
SqlCommand cmdDataBase = new SqlCommand("select * from SecMes", conDataBase);
try
{
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmdDataBase;
DataTable dt = new DataTable();
sda.Fill(dt);
DataView dv = new DataView(dt);
dv.RowFilter = string.Format("Receiver Like '%{0}%'", secretary.getID());
dataGridView1.DataSource = dv;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void pictureBox2_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(constring);
con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO SecMes (Sender, Receiver, Body) VALUES (@Sender, @Receiver, @Body)", con);
cmd.Parameters.Add("@Sender", student.getName());
cmd.Parameters.Add("@Receiver", secretary.getID());
cmd.Parameters.Add("@Body", textBox1.Text);
if (cmd.ExecuteNonQuery() == 1)
{
MessageBox.Show("Inserting Data Successfully");
con.Close();
pictureBox1_Click(sender, e); // exit
}
else
{
MessageBox.Show("Inserting Data Failed");
}
}
