Save Specific column values from GridView columns to Database using C# in ASP.Net

Question

I have a gridview It has 9columnsIn my database table i have 5 column  From this 9columns we have to save 5 columnsHow to get Specific Column names matched with the table column name

AnandM · Accepted Answer

Hi  Vasanth057Refer below Article and modify your code according to your requirementUsing SqlBulkCopy to insert bulk data from GridView to database in ASPNetand refer below code where you need to modifiy itprotected void BulkInsertobject sender EventArgs e    DataTable dt  new DataTable    dtColumnsAddRangenew DataColumn3  new DataColumn34Id34 typeofint                    new DataColumn34Name34 typeofstring                    new DataColumn34Country34typeofstring     foreach GridViewRow row in GridView1Rows            int id  intParserowCells1Text get only 5 row values and add it to the datatable        string name  rowCells2Text        string country  rowCells3Text        dtRowsAddid name country        if dtRowsCount gt 0            string consString  ConfigurationManagerConnectionStrings34constr34ConnectionString        using SqlConnection con  new SqlConnectionconsStrin

Save Specific column values from GridView columns to Database using C# in ASP.Net

Company

Explore

Follow us

Contact Us