how to insert data from grideview to the database

jemin patel

9y958.NET

I have two table 1 cart and 2 order info

1 cart table

a_id (primary key)

u_id (user_id) (foreign key)

d_id (desing id) (foreign key)

d_code

d_name

d_category

body_part

price

image (URl)

2 orderinfo

o_id (primary key)

d_id (foreign key)

u_id (foreign key)

o_code

o_name

o_category

o_part

o_price

o_date

image (URl)

status (Pending / completed)

above are the table as per the website

issue

i want to take the data from gridview to my orderinfo table.the gridview show the data from the cart table .as i click on button the data should be insert to the orderinfo table

i use asp.net with c# Language in visual studio 2010 and microsoft sql server2005

2 Replies

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

Rajeesh Menoth9y ago
Hi,

You can try with following article reference and use parameterized query instead of inline code.

Reference :

http://www.c-sharpcorner.com/UploadFile/satyapriyanayak/insert-edit-update-in-gridview-using-single-stored-procedure/

http://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-from-data-into-database-using-stored-procedure-in/

http://www.aspdotnet-suresh.com/2016/06/insert-data-into-database-in-aspnet-using-stored-procedure-csharp-vbnet.html
0
Ankit Sharma9y ago
hi,

please refer to these links

http://www.aspdotnet-suresh.com/2016/07/insert-data-from-gridview-to-database-in-aspnet-using-csharp-vbnet.html

http://www.c-sharpcorner.com/blogs/insert-data-into-database-from-gridview-in-asp-net1

http://www.c-sharpcorner.com/UploadFile/b926a6/insert-data-in-database-using-gridview-control/
0