HOW TO INSERT GRIDVIEW DATA INTO SQL TABLE

Question

I have a condition that i have to insert grid view data into sql table. gridview have multiple row.

on click button i have to submit records at a time in table using c#.

SN.

	Team	Agent	Amount withdraw	Done
1	ABC	Manish	6416	10
2	Luv	Anand	23401	6
3	ABC	Azaz	21200	7
4	ABC	Sunil	19200	5
5	Luv	Jyoti	14600	6
6	Luv	Neeraj	14451	10
7	VIRA	Priyanka	13100	7

Rakesh · Answer

Hi grid bulk record insert try this: http://www.c-sharpcorner.com/UploadFile/b926a6/insert-multiple-bulk-data-row-in-database-using-xml-in-asp-n/

Ayappan Alagesan · Answer

Convert griddata to datatable. Here is one example for pushing a datatable to sql table. CREATE TYPE [ dbo ].[ MyTableType ] AS TABLE ( [ Id ] int NOT NULL  [ Name ] [ nvarchar ]( 128 ) NULL ) CREATE PROCEDURE [ dbo ].[ InsertTable ] @myTableType MyTableType readonly AS BEGIN insert into [ dbo ]. Records select * from @myTableType END and send your DataTable directly to sql server: using ( var command = new SqlCommand ( InsertTable ) { CommandType = CommandType . StoredProcedure }) { var dt = new DataTable (); //create your own data table command . Parameters . Add ( new SqlParameter ( @myTableType  dt )); SqlHelper . Exec ( command ); }

Bikesh Srivastava · Answer

http://www.aspsnippets.com/Articles/Insert-Save-Multiple-rows-from-DataGridView-to-Database-in-Windows-Forms-WinForms-Application-using-C-and-VBNet.aspx Go on this link.