inserting data from tablepanellayout to sql server database

Question

hello sir I am developing desktop application in which i want to insert data from dynamically generated textboxes in tablepanelayout to sql server database by using C# code. please suggest me proper solution.

Rajkiran Swain · Answer

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 { 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 row 2 = new TableRow(); TableCell cell 11 = new TableCell(); TableCell cell 12 = new TableCell(); TableCell cell 13 = new TableCell(); TableCell cell 14 = new TableCell(); TableCell cell 15 = new TableCell(); TableCell cell 16 = new TableCell(); TableCell cell 21 = new TableCell(); TableCell cell 22 = new TableCell(); TableCell cell 23 = new TableCell(); TableCell cell 24 = new TableCell(); TableCell cell 25 = new TableCell(); TableCell cell 26 = new TableCell(); cell 11 .Controls.Add(lblChassis); cell 12 .Controls.Add(txtChassis); cell 13 .Controls.Add(lblEngno); cell 14 .Controls.Add(txtEngno); cell 15 .Controls.Add(lblColour); cell 16 .Controls.Add(txtColour); cell 21 .Controls.Add(lblInvest); cell 22 .Controls.Add(txtInvest); cell 23 .Controls.Add(lblFrieght); cell 24 .Controls.Add(txtFrieght); cell 25 .Controls.Add(lblYear); cell 26 .Controls.Add(txtYear); row.Cells.Add(cell 11 ); row.Cells.Add(cell 12 ); row.Cells.Add(cell 13 ); row.Cells.Add(cell 14 ); row.Cells.Add(cell 15 ); row.Cells.Add(cell 16 ); row 2 .Cells.Add(cell 21 ); row 2 .Cells.Add(cell 22 ); row 2 .Cells.Add(cell 23 ); row 2 .Cells.Add(cell 24 ); row 2 .Cells.Add(cell 2 shankhan 0 9 -Sep -12 9: 23 am row 2 .Cells.Add(cell 21 ); row 2 .Cells.Add(cell 22 ); row 2 .Cells.Add(cell 23 ); row 2 .Cells.Add(cell 24 ); row 2 .Cells.Add(cell 25 ); row 2 .Cells.Add(cell 26 ); row.BackColor = System.Drawing.Color.LightGray; row 2 .BackColor = System.Drawing.Color.LightGray; tbl.Rows.Add(row); tbl.Rows.Add(row 2 ); TableRow row 3 = new TableRow(); row 3 .Cells.Add(new TableCell()); tbl.Rows.Add(row 3 ); } 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 { 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 carint.Parse( txtQuantity.Text.ToString())); } catch (Exception ex) { lblStatus.Text = ex.Message; } }