HOW TO INSERT GRIDVIEW DATA INTO SQL TABLE

Vandana

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rakesh9y ago
Accepted 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 Alagesan9y ago

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 Srivastava9y ago
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.