inserting data from tablepanellayout to sql server database

protected void btngenerate_Click(object sender, EventArgs e)
{
Table tbl = new Table();
//btngenerate.Enabled = false;
btnaddquantity.Enabled = true;
try
{
ViewState["quantity"] = int.Parse(txtQuantity.Text.ToString());
}
catch (Exception ex)
{
lblStatus.Text = ex.Message;
}
for (int i = 1; i <= int.Parse( txtQuantity.Text); i++)
{
TextBox txtEngno = new TextBox();
TextBox txtChassis = new TextBox();
TextBox txtColour = new TextBox();
TextBox txtInvest = new TextBox();
TextBox txtFrieght = new TextBox();
TextBox txtYear = new TextBox();
Label lblEngno = new Label();
Label lblChassis = new Label();
Label lblColour = new Label();
Label lblInvest = new Label();
Label lblFrieght = new Label();
Label lblYear = new Label();
txtYear.ID = "txtYear" + i;
txtEngno.ID = "txtEngno" + i;
txtChassis.ID = "txtChassis" + i;
txtColour.ID = "txtColour" + i;
txtFrieght.ID = "txtFrieght" + i;
txtInvest.ID = "txtInvest" + i;
txtYear.ClientIDMode=ClientIDMode.Static;
//txtEngno.ClientIDMode = txtChassis.ClientIDMode = txtFrieght.ClientIDMode = txtColour.ClientIDMode = txtInvest.ClientIDMode =
lblEngno.ID= "lblEngno-"+i;
lblChassis.ID = "lblChassis-" + i;
lblColour.ID = "lblColor-" + i;
lblYear.ID = "lblYear" + i;
lblInvest.ID = "lblInvest" + i;
lblFrieght.ID = "lblFrieght" + i;
lblEngno.Text="Engine No. :";
lblYear.Text = "Year :";
lblInvest.Text = "Investment Price :";
lblFrieght.Text = "Frieght Price :";
lblChassis.Text="Chassis No. :";
lblColour.Text = "Colour :";
TableRow row = new TableRow();
TableRow row2 = new TableRow();
TableCell cell11 = new TableCell();
TableCell cell12 = new TableCell();
TableCell cell13 = new TableCell();
TableCell cell14 = new TableCell();
TableCell cell15 = new TableCell();
TableCell cell16 = new TableCell();
TableCell cell21 = new TableCell();
TableCell cell22 = new TableCell();
TableCell cell23 = new TableCell();
TableCell cell24 = new TableCell();
TableCell cell25 = new TableCell();
TableCell cell26 = new TableCell();
cell11.Controls.Add(lblChassis);
cell12.Controls.Add(txtChassis);
cell13.Controls.Add(lblEngno);
cell14.Controls.Add(txtEngno);
cell15.Controls.Add(lblColour);
cell16.Controls.Add(txtColour);
cell21.Controls.Add(lblInvest);
cell22.Controls.Add(txtInvest);
cell23.Controls.Add(lblFrieght);
cell24.Controls.Add(txtFrieght);
cell25.Controls.Add(lblYear);
cell26.Controls.Add(txtYear);
row.Cells.Add(cell11);
row.Cells.Add(cell12);
row.Cells.Add(cell13);
row.Cells.Add(cell14);
row.Cells.Add(cell15);
row.Cells.Add(cell16);
row2.Cells.Add(cell21);
row2.Cells.Add(cell22);
row2.Cells.Add(cell23);
row2.Cells.Add(cell24);
row2.Cells.Add(cell2
shankhan0 9-Sep-12 9:23am
row2.Cells.Add(cell21);
row2.Cells.Add(cell22);
row2.Cells.Add(cell23);
row2.Cells.Add(cell24);
row2.Cells.Add(cell25);
row2.Cells.Add(cell26);
row.BackColor = System.Drawing.Color.LightGray;
row2.BackColor = System.Drawing.Color.LightGray;
tbl.Rows.Add(row);
tbl.Rows.Add(row2);
TableRow row3 = new TableRow();
row3.Cells.Add(new TableCell());
tbl.Rows.Add(row3);
}
PlaceHolderTbl.Controls.Add(tbl);
//tbl.EnableViewState = true;
//tblVehicleInfo.EnableViewState = true;
//ViewState["atbl"] = tbl;
//Session["atbl"] = tbl;
}
protected void btnaddquantity_Click(object sender, EventArgs e)
{
List lst = new List();
Vehicle car = new Vehicle ();
car.company = lstCompany.SelectedItem.Text.ToString();
car.model = lstModel.SelectedItem.Text.ToString();
try
{
//Table tbl = PlaceHolderTbl.FindControl("tbl") as Table;
// Table tbl = Session["atbl"] as Table;
//Session.Remove("atbl");
int rows = int.Parse(ViewState["quantity"].ToString());
if (rows>0)
{
for (int i = 1; i <= rows; i++)
{
VehicleDetails a = new VehicleDetails();
a.chassis = (Request.Form["txtChassis" + i]);
a.engine = (Request.Form["txtEngno" + i]);
a.colour = (Request.Form["txtColour-" + i]);
a.frieghtprice = int.Parse((Request.Form["txtFrieght" + i]));
a.investprice = int.Parse((Request.Form["txtInvest" + i]));
a.year = (Request.Form["txtYear" + i]);
lst.Add(a);
//a.chassis = (tbl.FindControl("txtChassis-" + i) as TextBox).Text.ToString();
//a.engine = (tbl.FindControl("txtEngno-" + i) as TextBox).Text.ToString();
//a.colour = (tbl.FindControl("txtColour-" + i) as TextBox).Text.ToString();
//a.frieghtprice = int.Parse((tbl.FindControl("txtFrieght-" + i) as TextBox).Text.ToString());
//a.investprice = int.Parse((tbl.FindControl("txtInvest-" + i) as TextBox).Text.ToString());
//a.year = (tbl.FindControl("txtYear-" + i) as TextBox).ToString();
//lst.Add(a);
}
lst.TrimExcess();
}
garage grg = new garage();
grg.AddQuantity(lst, car,int.Parse( txtQuantity.Text.ToString()));
}
catch (Exception ex)
{
lblStatus.Text = ex.Message;
}
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rajkiran Swain8y ago
Accepted answer
1. protected void btngenerate_Click(object sender, EventArgs e)
2. {
3. Table tbl = new Table();
4. //btngenerate.Enabled = false;
5. btnaddquantity.Enabled = true;
6. try
7. {
8. ViewState["quantity"] = int.Parse(txtQuantity.Text.ToString());
9. }
10. catch (Exception ex)
11. {
13. lblStatus.Text = ex.Message;
14. }
16. for (int i = 1; i <= int.Parse( txtQuantity.Text); i++)
17. {
18. TextBox txtEngno = new TextBox();
19. TextBox txtChassis = new TextBox();
20. TextBox txtColour = new TextBox();
21. TextBox txtInvest = new TextBox();
22. TextBox txtFrieght = new TextBox();
23. TextBox txtYear = new TextBox();
24. Label lblEngno = new Label();
25. Label lblChassis = new Label();
26. Label lblColour = new Label();
27. Label lblInvest = new Label();
28. Label lblFrieght = new Label();
29. Label lblYear = new Label();
31. txtYear.ID = "txtYear" + i;
32. txtEngno.ID = "txtEngno" + i;
33. txtChassis.ID = "txtChassis" + i;
34. txtColour.ID = "txtColour" + i;
35. txtFrieght.ID = "txtFrieght" + i;
36. txtInvest.ID = "txtInvest" + i;
37. txtYear.ClientIDMode=ClientIDMode.Static;
38. //txtEngno.ClientIDMode = txtChassis.ClientIDMode = txtFrieght.ClientIDMode = txtColour.ClientIDMode = txtInvest.ClientIDMode =
40. lblEngno.ID= "lblEngno-"+i;
41. lblChassis.ID = "lblChassis-" + i;
42. lblColour.ID = "lblColor-" + i;
43. lblYear.ID = "lblYear" + i;
44. lblInvest.ID = "lblInvest" + i;
45. lblFrieght.ID = "lblFrieght" + i;
48. lblEngno.Text="Engine No. :";
49. lblYear.Text = "Year :";
50. lblInvest.Text = "Investment Price :";
51. lblFrieght.Text = "Frieght Price :";
52. lblChassis.Text="Chassis No. :";
53. lblColour.Text = "Colour :";
57. TableRow row = new TableRow();
58. TableRow row2 = new TableRow();
60. TableCell cell11 = new TableCell();
61. TableCell cell12 = new TableCell();
62. TableCell cell13 = new TableCell();
63. TableCell cell14 = new TableCell();
64. TableCell cell15 = new TableCell();
65. TableCell cell16 = new TableCell();
66. TableCell cell21 = new TableCell();
67. TableCell cell22 = new TableCell();
68. TableCell cell23 = new TableCell();
69. TableCell cell24 = new TableCell();
70. TableCell cell25 = new TableCell();
71. TableCell cell26 = new TableCell();
74. cell11.Controls.Add(lblChassis);
75. cell12.Controls.Add(txtChassis);
76. cell13.Controls.Add(lblEngno);
77. cell14.Controls.Add(txtEngno);
78. cell15.Controls.Add(lblColour);
79. cell16.Controls.Add(txtColour);
81. cell21.Controls.Add(lblInvest);
82. cell22.Controls.Add(txtInvest);
83. cell23.Controls.Add(lblFrieght);
84. cell24.Controls.Add(txtFrieght);
85. cell25.Controls.Add(lblYear);
86. cell26.Controls.Add(txtYear);
88. row.Cells.Add(cell11);
89. row.Cells.Add(cell12);
90. row.Cells.Add(cell13);
91. row.Cells.Add(cell14);
92. row.Cells.Add(cell15);
93. row.Cells.Add(cell16);
95. row2.Cells.Add(cell21);
96. row2.Cells.Add(cell22);
97. row2.Cells.Add(cell23);
98. row2.Cells.Add(cell24);
99. row2.Cells.Add(cell2
100. shankhan0 9-Sep-12 9:23am
102. row2.Cells.Add(cell21);
103. row2.Cells.Add(cell22);
104. row2.Cells.Add(cell23);
105. row2.Cells.Add(cell24);
106. row2.Cells.Add(cell25);
107. row2.Cells.Add(cell26);
108. row.BackColor = System.Drawing.Color.LightGray;
109. row2.BackColor = System.Drawing.Color.LightGray;
110. tbl.Rows.Add(row);
112. tbl.Rows.Add(row2);
113. TableRow row3 = new TableRow();
114. row3.Cells.Add(new TableCell());
115. tbl.Rows.Add(row3);
117. }
118. PlaceHolderTbl.Controls.Add(tbl);
119. //tbl.EnableViewState = true;
120. //tblVehicleInfo.EnableViewState = true;
122. //ViewState["atbl"] = tbl;
123. //Session["atbl"] = tbl;
127. }
129. protected void btnaddquantity_Click(object sender, EventArgs e)
130. {
132. List lst = new List();
133. Vehicle car = new Vehicle ();
134. car.company = lstCompany.SelectedItem.Text.ToString();
135. car.model = lstModel.SelectedItem.Text.ToString();
136. try
137. {
138. //Table tbl = PlaceHolderTbl.FindControl("tbl") as Table;
139. // Table tbl = Session["atbl"] as Table;
140. //Session.Remove("atbl");
141. int rows = int.Parse(ViewState["quantity"].ToString());
142. if (rows>0)
143. {
144. for (int i = 1; i <= rows; i++)
145. {
146. VehicleDetails a = new VehicleDetails();
147. a.chassis = (Request.Form["txtChassis" + i]);
148. a.engine = (Request.Form["txtEngno" + i]);
149. a.colour = (Request.Form["txtColour-" + i]);
150. a.frieghtprice = int.Parse((Request.Form["txtFrieght" + i]));
151. a.investprice = int.Parse((Request.Form["txtInvest" + i]));
152. a.year = (Request.Form["txtYear" + i]);
153. lst.Add(a);
154. //a.chassis = (tbl.FindControl("txtChassis-" + i) as TextBox).Text.ToString();
155. //a.engine = (tbl.FindControl("txtEngno-" + i) as TextBox).Text.ToString();
156. //a.colour = (tbl.FindControl("txtColour-" + i) as TextBox).Text.ToString();
157. //a.frieghtprice = int.Parse((tbl.FindControl("txtFrieght-" + i) as TextBox).Text.ToString());
158. //a.investprice = int.Parse((tbl.FindControl("txtInvest-" + i) as TextBox).Text.ToString());
159. //a.year = (tbl.FindControl("txtYear-" + i) as TextBox).ToString();
160. //lst.Add(a);
161. }
162. lst.TrimExcess();
163. }
166. garage grg = new garage();
167. grg.AddQuantity(lst, car,int.Parse( txtQuantity.Text.ToString()));
168. }
169. catch (Exception ex)
170. {
172. lblStatus.Text = ex.Message;
173. }
176. }