Insert Data from dynamically Generated Rows into Database using C# and VB.Net in ASP.Net

Question

httpwwwaspsnippetscomArticlesAddingDynamicRowsinASPNetGridViewControlwithTextBoxesaspxHi I have gone through the above article on how to generate a row dynamically with textboxes using a gridview in aspnet and its a wonderful articleAs in the above article has a gridview with 4 columns 1 Row Numbr2 Header 13 Header 2 and4 Header 3I want to store the same into table created in sqlserver and reterive the same when needed How can i acheive this kindly help me out Thanks

Andrea · Accepted Answer

Hi AbdulHaquePlease try the followinginsert data from one Table into other Table if data does not exists in SQL ServerIt might help youCheers Andrea

dharmendr · Answer

Hi AbdulHaqueRefer the below code for insert on click of button outside the gridviewCprotected void btnInsertobject sender EventArgs e    foreach GridViewRow row in Gridview1Rows            string rowNo  rowCells0Text        string header1  rowFindControl34TextBox134 as TextBoxText        string header2  rowFindControl34TextBox234 as TextBoxText        string header3  rowFindControl34TextBox334 as TextBoxText         Insert code here        InsertrowNo header1 header2 header3    private void Insertstring rowNo string header1 string header2 string header3    string constr  ConfigurationManagerConnectionStrings34constr34ConnectionString    using SqlConnection con  new SqlConnectionconstr            using SqlCommand cmd  new SqlCommand34INSERT INTO Test VALUESRowNoHeader1Header2Header334                    cmdConnection  con            cmdParametersAddWithValue34RowN

Insert Data from dynamically Generated Rows into Database using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us