Help me to store my Grid View data in database in asp.net

Question

I 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.... 

Answer 1

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。

Sample at：http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx

Thx

---

   QQ我：
下载MSDN桌面工具(Vista,Win7)
我的博客园
慈善点击，点击此处

Answer 2

Hi Aashis,
How is it going with Wei_Dong’s suggestion?
If you want to more special code about how to do this, you can create a new thread in the ASP.NET Forum, but I think the idea is similar.
Best Regards,

---

Bob Wu [MSFT]
MSDN Community Support | Feedback to us