How to insert Checked value of checkbox in gridview in db ?

Question

How to insert Checked value of checkbox in gridview in db in asp .net? like this All this selected values should get inserted in to my database along with date/time . pls help!!!

Parth Mashroo · Answer

Yes i did the same thing replaced textbox with label in the code and worked thanx for your helps and reply i did the same code editing before looking ate your reply but its gud to know that i was on the same track thanx to u i will upload the solution for other people to understand. once again thanx!!!

Khargesh Rajput · Answer

Parth given link has working code. use that code and add datetime to boundfield

Khargesh Rajput · Answer

http://www.c-sharpcorner.com/Blogs/11011/ in above link where you checked row selected and inserting data  you can add a datetime field of your database and insert date in that column or use datatable and bind a column for date and insert to database or inside gridview bind date in gridview and set visible false if you dont want to show in gridview and want to insert in db

Munesh Sharma · Answer

http://www.aspsnippets.com/Articles/Populate-bind-CheckBox-in-GridView-from-database-in-ASPNet-using-C-and-VBNet.aspx

Khargesh Rajput · Answer

http://www.c-sharpcorner.com/Blogs/11011/ or you can use bulk insert to save all http://www.aspsnippets.com/Articles/Using-SqlBulkCopy-to-insert-bulk-data-from-GridView-to-database-in-ASPNet.aspx

Khargesh Rajput · Answer

you are find control from grid of data from edititemtemplate. but you have to find control from itemtemplate e.g. for Name use label Id=row.findcontrol(Label5) as Label label Name=row.findcontrol(Label1) as Label use same as for emailid and other controls

Parth Mashroo · Answer

Khargesh Rajput · Answer

hi parth . i cant attatch your database but if you want to insert current date as i have seen in c# code. you can do this and not need to insert date by qeury then create table dbo .dashboard ( id int  name varchar(50)  emailid varchar (50) date DateTimeOffset NOT NULL default SYSDATETIMEOFFSET () ); OR by wizard

Parth Mashroo · Answer

Sir this is my source Code and i have included all the thing now sir i am using visual studio 2012 and sir i am having trouble inserting data and shows some error pls help me on this. i am inserting this code at the same time sending email to actually i want to create a dashboard of all the emails sent so i want to create this insert code.and the display it in other grid view so pls help me on this...!!! thanx once again for your reply!!!

Parth Mashroo · Answer

Sir Can you write me the code for it I have colums U_IdNameEmail_Id and Checkbox in my gridview i want to insert the data from this gridview into the table with same field and also want to insert date/time . But only selected data should be inserted. pls helppls and thanx for reply.!!!

Parth Mashroo · Answer

Sir i want to insert data from gridview where chckbox are checked but i also want to insert date/time which is not in the coloum of gridview can you help me on that.. and thanks for your reply. pls help me on that!!!!