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, car,int.Parse( txtQuantity.Text.ToString())); } catch (Exception ex) { lblStatus.Text = ex.Message; } }

inserting data from tablepanellayout to sql server database

Ankur Gupta

Crish

Ayesha balooshi

DRISHTY

Ankur Gupta