How to insert multiple rows of data of grid view in C#.Net to database at a time or single button click?

Question

HI,
I have a grid view in a windows application project.In the grid I can add multiple data in multiple rows.I just want to save those multiple rows with full of data in to a single table .
thanx

Answer 1

i want C# codeing with sql query.iam using datagridview.can anybody help me
thanx

Answer 2

Hi
u can use BulkInsert of sqlserver.For more info
"http://msdn.microsoft.com/en-us/library/ms188365.aspx"
"http://msdn.microsoft.com/en-us/library/ms175915.aspx"