Save all records from GridView to Database on Button click in ASP.Net

Question

As I am creating a asp page with database valuesAnd I am showing in Gridviewin addition I need checkbox for each row When I mark checkbox the row values to be stored in another table Can anyone help me

Mudassar · Accepted Answer

ReferUsing SqlBulkCopy to insert bulk data from GridView to database in ASPNet

Azim · Answer

You need to replace TemplateField with BoundFieldYou can see the GridView in the articleUsing SqlBulkCopy to insert bulk data from GridView to database in ASPNet Its having BoundField for Id Name Country that needs to be added in the DatabaseltaspGridView ID34GridView134 runat34server34 AutoGenerateColumns34false34gtltColumnsgt    ltaspTemplateFieldgt        ltItemTemplategt            ltaspCheckBox ID34CheckBox134 runat34server34 gt        ltItemTemplategt    ltaspTemplateFieldgt    ltaspBoundField DataField34Id34 HeaderText34Id34 ItemStyleWidth343034 gt    ltaspBoundField DataField34Name34 HeaderText34Name34 ItemStyleWidth3415034 gt    ltaspBoundField DataField34Country34 HeaderText34Country34 ItemStyleWidth3415034 gtltColumnsgtltaspGridViewgt

Save all records from GridView to Database on Button click in ASP.Net

Company

Explore

Follow us

Contact Us