01.protected void Button3_Click(object sender, EventArgs e)
02. {
03. ListItemCollection listLine = new ListItemCollection();
04. listLine.Add(new ListItem(DropDownList11.SelectedItem.Text, DropDownList11.SelectedValue));
05. listLine.Add(new ListItem(DropDownList12.SelectedItem.Text, DropDownList12.SelectedValue));
06. listLine.Add(new ListItem(DropDownList13.SelectedItem.Text, DropDownList13.SelectedValue));
07. listLine.Add(new ListItem(DropDownList14.SelectedItem.Text, DropDownList14.SelectedValue));
08. listLine.Add(new ListItem(DropDownList15.SelectedItem.Text, DropDownList15.SelectedValue));
09. listLine.Add(new ListItem(DropDownList16.SelectedItem.Text, DropDownList16.SelectedValue));
10. listLine.Add(new ListItem(DropDownList17.SelectedItem.Text, DropDownList17.SelectedValue));
11. listLine.Add(new ListItem(DropDownList18.SelectedItem.Text, DropDownList18.SelectedValue));
12. listLine.Add(new ListItem(DropDownList19.SelectedItem.Text, DropDownList19.SelectedValue));
13. listLine.Add(new ListItem(DropDownList20.SelectedItem.Text, DropDownList20.SelectedValue));
14. listLine.Add(new ListItem(DropDownList21.SelectedItem.Text, DropDownList21.SelectedValue));
15. listLine.Add(new ListItem(DropDownList22.SelectedItem.Text, DropDownList22.SelectedValue));
16. listLine.Add(new ListItem(DropDownList33.SelectedItem.Text, DropDownList33.SelectedValue));
17.
18. DataSet ds = new DataSet();
19. DataTable dt = new DataTable();
20.
21.
22. foreach (ListItem item in listLine)
23. {
24. dt.Columns.Add(item.Text);
25. }
26.
27. ds.Tables.Add(dt);
28. ds.AcceptChanges();
29.
30. GridView3.DataSource = listLine;
31. GridView3.DataBind();
32.
33.
34.
35. SqlConnection myConn = new SqlConnection(WebConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);
36.
37. if (myConn.State == ConnectionState.Closed)
38. myConn.Open();
39. string sql = "";
40. SqlTransaction tr = myConn.BeginTransaction();
41. SqlCommand cmd = myConn.CreateCommand();
42.
43.
44. cmd.CommandType = CommandType.Text;
45. cmd.Transaction = tr;
46.
47. int F01;
48. int F02;
49. int F03;
50. int F04;
51. int F05;
52. int F06;
53. int F07;
54. int F08;
55. int F09;
56. int F10;
57. int F11;
58. int F12;
59. int F13;
60. F01 = int.Parse(GridView3.Rows[0].Cells[3].Text.Trim());
61. F02 = int.Parse(GridView3.Rows[1].Cells[3].Text.Trim());
62. F03 = int.Parse(GridView3.Rows[2].Cells[3].Text.Trim());
63. F04 = int.Parse(GridView3.Rows[3].Cells[3].Text.Trim());
64. F05 = int.Parse(GridView3.Rows[4].Cells[3].Text.Trim());
65. F06 = int.Parse(GridView3.Rows[5].Cells[3].Text.Trim());
66. F07 = int.Parse(GridView3.Rows[6].Cells[3].Text.Trim());
67. F08 = int.Parse(GridView3.Rows[7].Cells[3].Text.Trim());
68. F09 = int.Parse(GridView3.Rows[8].Cells[3].Text.Trim());
69. F10 = int.Parse(GridView3.Rows[9].Cells[3].Text.Trim());
70. F11 = int.Parse(GridView3.Rows[10].Cells[3].Text.Trim());
71. F12 = int.Parse(GridView3.Rows[11].Cells[3].Text.Trim());
72. F13 = int.Parse(GridView3.Rows[12].Cells[3].Text.Trim());
73. cmd.CommandText = "Insert Into VendorExportTemplate (VendorNo,SourceID,ExportOption,F01,F02,F03,F04,F05,F06,F07,F08,F09,F10,F11,F12,F13) " +
74.
75. " values ('" + DVendor.SelectedValue + "','L','UserDefine','" + F01 + "','" + F02 + "','" + F03 + "','" + F04 + "','" + F05 + "','" + F06 + "','" + F07 + "','" + F08 + "','" + F09 + "','" + F10 + "','" + F11 + "','" + F12 + "','" + F13 + "')";
76. cmd.ExecuteNonQuery();
77.
78. tr.Commit();
79. }
