Friday, April 13, 2012 2:06 AMI an doing a project in asp.net and here i am filling up my gridview from an excel file. Upto here its ok... now after the datas are filled from a excel in my grid i want to save these data to my sql server table "RCBook". I have columns such as name, regno, date, size, weight and so on. Plz tell me how to save it in my database bcoz afterwords i have to take out particular record from it when some customer queries....
Friday, April 13, 2012 5:12 AM
Simply speaking，I think you can：
Use OleDbDataReader with Batch-Insert with the help of SqlBulkCopy，but first you should create a table in SQL whose scaffoldings are the same as what it is of DataTable。
Thursday, April 19, 2012 6:40 AMModerator