01.private void SponsorInsert(MSponsor tb_Sponsor)
02. {
03. tb_Sponsor.SponsorID = GenNewID("Sponsor");
04. SqlConnection con = new SqlConnection();
05. string strSQL = "Insert Into Sponsor (ID,Name,Address,Tel,DateTime,Money,Pic,CashierID)";
06. strSQL += "Values('" + tb_Sponsor.SponsorID + "','" + tb_Sponsor.SponsorName + "','" + tb_Sponsor.SponsorAddress + "','" + tb_Sponsor.SponsorTel + "',CAST('" + tb_Sponsor.SponsorDateTimeFormatEN + "' as datetime),'" + tb_Sponsor.SponsorMoney + "','" + tb_Sponsor.SponsorPic + "','" + tb_Sponsor.SponsorCashierID + "')";
07.
08. try
09. {
10. con.ConnectionString = strConn;
11. con.Open();
12. SqlCommand com = new SqlCommand();
13. com.Connection = con;
14. com.CommandType = CommandType.Text;
15. com.CommandText = strSQL;
16. int chk = 0;
17. chk = com.ExecuteNonQuery();
18.
19. if (chk != 0)
20. {
21.
22. FindSponsor(tb_Sponsor.SponsorName);
23. Clear();
24. MessageBox.Show(insertsuccess, "Carvaly", MessageBoxButtons.OK, MessageBoxIcon.Information);
25. }
26. else
27. {
28. MessageBox.Show(inserterror, "Carvaly", MessageBoxButtons.OK, MessageBoxIcon.Error);
29. }
30. }
31. catch { MessageBox.Show(inserterror, "Carvaly", MessageBoxButtons.OK, MessageBoxIcon.Error); }
32. finally
33. {
34. con.Close();
35. }
36. }
