01.Connection.connnectsql3();
02.SqlConnection conC = new SqlConnection(Connection.strcon3);
03.{
04. using (SqlCommand command1 = new SqlCommand())
05. {
06.
07. command1.Connection = conC;
08. command1.CommandText = "INSERT INTO main_A_file_Tbank(save_date, coop_code, mem_id, cif_number, branch_code, Thai_name, Eng_name, cif_service_code, saving_no, acc_type, current_no, current_acc_type, card_no, status_flg, id_no, date_rec_card, flg_save_in_coop) VALUES (GETDATE(),'601', @mem_id, @cif_number, @branch_code, @Thai_name, @Eng_name, @cif_service_code, @saving_no, @acc_type, @current_no, @current_acc_type, @card_no, @status_flg, @id_no,GETDATE(), 'S')";
09. command1.Parameters.Add(new SqlParameter("@save_date", SqlDbType.DateTime));
10. command1.Parameters.Add(new SqlParameter("@coop_code", SqlDbType.VarChar));
11. command1.Parameters.Add(new SqlParameter("@mem_id", SqlDbType.NVarChar));
12. command1.Parameters.Add(new SqlParameter("@cif_number", SqlDbType.NVarChar));
13. command1.Parameters.Add(new SqlParameter("@branch_code", SqlDbType.NVarChar));
14. command1.Parameters.Add(new SqlParameter("@Thai_name", SqlDbType.NVarChar));
15. command1.Parameters.Add(new SqlParameter("@Eng_name", SqlDbType.NVarChar));
16. command1.Parameters.Add(new SqlParameter("@cif_service_code", SqlDbType.NVarChar));
17. command1.Parameters.Add(new SqlParameter("@saving_no", SqlDbType.NVarChar));
18. command1.Parameters.Add(new SqlParameter("@acc_type", SqlDbType.NVarChar));
19. command1.Parameters.Add(new SqlParameter("@current_no", SqlDbType.NVarChar));
20. command1.Parameters.Add(new SqlParameter("@current_acc_type", SqlDbType.NVarChar));
21. command1.Parameters.Add(new SqlParameter("@card_no", SqlDbType.NVarChar));
22. command1.Parameters.Add(new SqlParameter("@status_flg", SqlDbType.NVarChar));
23. command1.Parameters.Add(new SqlParameter("@id_no", SqlDbType.NVarChar));
24. command1.Parameters.Add(new SqlParameter("@date_rec_card", SqlDbType.Date));
25. command1.Parameters.Add(new SqlParameter("@flg_save_in_coop", SqlDbType.NVarChar));
26. conC.Open();
27. foreach (DataGridViewRow row in dataGridView1.Rows)
28. {
29. if (!row.IsNewRow)
30. {
31. command1.Parameters["@save_date"].Value = row.Cells[0].Value;
32. command1.Parameters["@coop_code"].Value = row.Cells[1].Value;
33. command1.Parameters["@mem_id"].Value = row.Cells[2].Value;
34. command1.Parameters["@cif_number"].Value = row.Cells[3].Value;
35. command1.Parameters["@branch_code"].Value = row.Cells[4].Value;
36. command1.Parameters["@Thai_name"].Value = row.Cells[5].Value;
37. command1.Parameters["@Eng_name"].Value = row.Cells[6].Value;
38. command1.Parameters["@cif_service_code"].Value = row.Cells[7].Value;
39. command1.Parameters["@saving_no"].Value = row.Cells[8].Value;
40. command1.Parameters["@acc_type"].Value = row.Cells[9].Value;
41. command1.Parameters["@current_no"].Value = row.Cells[10].Value;
42. command1.Parameters["@current_acc_type"].Value = row.Cells[11].Value;
43. command1.Parameters["@card_no"].Value = row.Cells[12].Value;
44. command1.Parameters["@status_flg"].Value = row.Cells[13].Value;
45. command1.Parameters["@id_no"].Value = row.Cells[14].Value;
46. command1.Parameters["@date_rec_card"].Value = row.Cells[15].Value;
47. command1.Parameters["@flg_save_in_coop"].Value = row.Cells[16].Value;
48. command1.ExecuteNonQuery();
49. }
50. }
51.
52. AutoClosingMessageBox.Show("Send to A_File_Tbank", "Success", 2000);
53. conC.Close();
54. dataGridView1.Columns.Clear();
55. dataGridView1.Refresh();
56. }
57.}
