Bulk Insert From ASP.NET Web Form Using C#

Sign in to leave a comment.

• MY

  Marwa Youssef5y agoPosted Mar 21, 2021, 9:45 PM

  Why i have this error while everything is ok and the column name is right. " {"The given ColumnName 'Name' does not match up with any column in data source."} "
  • MY

    Marwa Youssef5y agoPosted Mar 22, 2021, 1:00 PM

    I checked many times and everything is ok. just if there is any column empty, how i can mapping it to let it takes null value ?
  • 

    Vithal Wadje5y agoPosted Mar 22, 2021, 11:51 AM

    Check column mapping in Excel , code and database
• GM

  Ganga M7y agoPosted Apr 18, 2019, 12:30 AM

  How to insert same record multiple time without using for loop
  • 

    Vithal Wadje7y agoPosted Aug 4, 2019, 2:04 PM

    This article explained same
• SP

  Sourav Paramanik8y agoPosted Jul 29, 2018, 5:20 AM

  The example is great. But I need to do one thing. I want to DELETE a row in the grid GridView1 when I am adding rows in function AddNewRecordRowToGrid() . How to delete it on that time
  • 

    Vithal Wadje7y agoPosted Nov 18, 2018, 10:03 AM

    Instead of adding use remove
• EM

  ejaz mirza8y agoPosted Feb 20, 2018, 12:47 AM

  I have paging concept in the grid i can update page only not all the grid values
• ST

  Sylvia Txy8y agoPosted Jan 4, 2018, 7:08 AM

  Hi, is there a way to input duplicate product id(primary key) values?
  • 

    Vithal Wadje8y agoPosted Jan 13, 2018, 3:22 AM

    Can you elaborate your question in details
• RH

  Rana Haris8y agoPosted Dec 10, 2017, 2:06 PM

  I was using your example to insert bulk data in DB. I added 800 Records in grid view and my computer got powered off/ Restarted due to some light fluctuation. is there any way to Get those 800 Records that have been added in Gridview not in Database?
  • 

    Vithal Wadje8y agoPosted Jan 13, 2018, 3:23 AM

    Yes , might be you are using less configuration
• 

  Hamid Khan9y agoPosted Sep 15, 2017, 6:47 AM

  How to bulk insert data in multiple tables at a time................
  • 

    Hamid Khan9y agoPosted Sep 20, 2017, 1:53 AM

    Hi in your code : //assigning Destination table name objbulk.DestinationTableName = "ProdcutsSold"; Can we put multiple table for destination, could you please one example , It would be really helpful..... Thanks
  • 

    Vithal Wadje9y agoPosted Sep 20, 2017, 1:43 AM

    As similar to shown in article , map your tables to destination table
  • 

    Vithal Wadje9y agoPosted Sep 20, 2017, 2:21 AM

    Whatever other tables you can assign here but your sqlbulk copy instance should be different , if your source and destination tables are different
• 

  Hamid Khan9y agoPosted Sep 7, 2017, 4:50 AM

  Very nice article........
• PC

  Pauline Chan10y agoPosted Jan 31, 2016, 10:40 PM

  My gridview dies not show in the web page. I didn't change anything from your codes. And also, the data table from where it is getting the data has records already
  • PC

    Pauline Chan10y agoPosted Jan 31, 2016, 11:00 PM

    i fixed it thanks! i Just remove the datasource to web and just putted it in the c# code.
  • 

    Vithal Wadje9y agoPosted Sep 12, 2017, 1:34 AM

    Yes right ,The datasource already defined from server side , you have to check whether you are following same steps
• 

  Vithal Wadje11y agoPosted Sep 18, 2015, 5:18 PM

  share me code
• RT

  Raj Trivedi11y agoPosted Sep 17, 2015, 2:16 PM

  I am trying the same thing but i am stuck at a place where i have also another table where detail of customer and grandtotal of all the products are stored and i am confused how to simultaneously insert the data in master table and detail with generating Invoice no after inserting the record successfully in both table. One more thing the invoice no should be same for the detail transaction and master transaction.
  • 

    Vithal Wadje9y agoPosted Sep 12, 2017, 1:38 AM

    Hope you have completed this task , I have seen your query very late
• 

  Vithal Wadje11y agoPosted Jan 24, 2015, 9:58 AM

  sure wait for next
• KK

  karthi keyan11y agoPosted Jan 23, 2015, 8:02 PM

  how to clear datatable sir and also i want to know about bulk update into datatable as bulk binsert explained below
  • PC

    Pauline Chan10y agoPosted Feb 12, 2016, 1:05 AM

    do you know how?
  • 

    Vithal Wadje9y agoPosted Sep 12, 2017, 1:45 AM

    How to make bulk insert already explained into the article, regarding datatable clear , you can do it in multiple ways as per your requirement. yourdatatable.Rows.clear() , will clear only rows , yourdatatable.clear() - clears all datatable.
• 

  Vithal Wadje11y agoPosted Jan 13, 2015, 1:08 PM

  can you explain your question
• KK

  karthi keyan11y agoPosted Jan 13, 2015, 7:29 AM

  Default.aspx file
• 

  Vithal Wadje11y agoPosted Jan 4, 2015, 2:25 AM

  no such a clear method for Rows
• KK

  karthi keyan11y agoPosted Jan 3, 2015, 2:47 PM

  when i use gridview1.Rows.Clear() it is showing an error System.Web.UI.WebControls.GridViewRowCollection' does not contain a definition for 'Clear' and no extension method 'Clear' accepting a first argument of type 'System.Web.UI.WebControls.GridViewRowCollection' could be found (are you missing a using directive or an assembly reference?)
  • 

    Vithal Wadje9y agoPosted Sep 12, 2017, 1:49 AM

    First set your gridview datasource as null i.e. gridview1.DataSource = null; then gridview1.Rows.Clear();
• KK

  karthi keyan11y agoPosted Dec 17, 2014, 3:56 AM

  it is updating sir but copy of same product name is updating newly i want to update in time field of existing productname
• 

  Vithal Wadje11y agoPosted Dec 16, 2014, 9:50 PM

  set the datetime.now function to variable from whcih you are inserting or updating records
• KK

  karthi keyan11y agoPosted Dec 16, 2014, 8:50 PM

  current date to already existing product name record sir
• 

  Vithal Wadje11y agoPosted Dec 16, 2014, 10:23 AM

  you wants to update current date or any other
• KK

  karthi keyan11y agoPosted Dec 16, 2014, 8:27 AM

  i fetched data from existing table and saved into another table its working fine as you referred and another question sir i want to update current date and time to same table. For eg if i type product name means automatically the product detail is fetching in the details i have to update current date and time help me sir
• 

  Vithal Wadje11y agoPosted Dec 11, 2014, 11:09 AM

  yes you can do it also,refer my article list and find autocomplete extender,it will help you
• KK

  karthi keyan11y agoPosted Dec 11, 2014, 10:08 AM

  Its working fine sir i made mistake in sql code and another one question sir i want to use only one textbox productname if i type productname means automatically the product detail has to fetch from another table in the database and has to fill in brandnamd, warranty, price in the gridview after clicking on saveproducts the data has to save in database table and also i need to clear the gridview data after clicking save products button
• 

  Vithal Wadje11y agoPosted Dec 10, 2014, 10:50 AM

  can you post your code
• KK

  karthi keyan11y agoPosted Dec 10, 2014, 8:02 AM

  database table cannot able to access is coming please i need help