private void btnSure_Click(object sender, EventArgs e)
{
DateTime Time = DateTime.Now;
String StrToday = "";
StrToday = Time.ToShortDateString().ToString();
if ((cbDStudent.Text.Length > 0) && (cbCompanyName.Text.Length > 0))
{
SqlConnection con = new SqlConnection(scsb.ToString());
con.Open();
string strSQL = "update Daily_Student set date=@StrToday,Comoany=@NewCompany where DS_name like @NewClass";
SqlCommand cmd = new SqlCommand(strSQL, con);
cmd.Parameters.AddWithValue("@NewClass", cbDStudent.Text);
cmd.Parameters.AddWithValue("@StrToday", StrToday);
cmd.Parameters.AddWithValue("@NewCompany", cbCompanyName.Text);
int rows = cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("已確定值日生");
form1 form = new form1();
form.name = cbDStudent.Text;
form.company = cbCompanyName.Text;
//form.ShowDialog();
}
else
{
MessageBox.Show("兩者不可為空");
}
}
private void btnStudent_Click(object sender, EventArgs e)
{
form1 form = new form1();
form.ShowDialog();
}
