Insert dynamically created rows into Database using C# and VB.Net in ASP.Net

Question

First let me thank all of you from this great resource especially Indresh for all the fantastic helpI have been able to insert dynamically created rows into the database successfullyHowever this one from the link below created by Indresh is a bit too complicatedhttpwwwaspforumsnetThreads148704ExtendingHideShowDeletebuttonfuntionalitiesReplies1RepliesThere are two gridview controls gvIncome and gvSpouseWhen a user creates multiple dynamic rows how do I insert those into th

Indresh · Accepted Answer

Hi simflexYou need to add Button outside gridview in your code So please refer the below code and modify as per your requirementHTMLltaspButton ID34btnIncone34 Text34Save Income34 CssClass34btnSuccess34 OnClick34OnSaveIncome34    runat34server34 gtltaspButton ID34btnSpouse34 Text34Save Spouse34 CssClass34btnSuccess34  OnClick34OnSaveSpouse34    runat34server34 gtCprotected void OnSaveIncomeobject sender EventArgs e    SqlConnection con  new SqlConnectioncontring    foreach GridViewRow row in gvIncomeRows            string Message  rowFindControl34txtspouseincome34 as TextBoxTextTrim        SqlCommand cmd  new SqlCommand34INSERT INTO TableName VALUESMessage34 con        cmdParametersAddWithValue34Message34 Message        conOpen        cmdExecuteNonQuery        conClose        thisSetInitialRowprotected void OnSaveSpouseobject s

Insert dynamically created rows into Database using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us