How can i update chechboxes in database.

Question

I am using a member table to get names from table and another Fee table so that to display the chechbox to show if fee is paid or not.
The database datatype is set as bit so that it displays a checkbox in the datagridview. How can i update my table if i chech any of the checkbox a screenshot can be seen below :

http://i52.tinypic.com/33lpdl1.jpg

Thanks

Sam Hobbs · Answer

Check the articles in this web site; there is probably one or more that shows how to do that.

Abhimanyu K Vatsa · Answer

each checkbox should have id. or u hv to use group checkbox concept

Mark Fenech · Answer

but refer to the screenshot there are more than 1 checkbox .... how would i know which 1 :S ?

Abhimanyu K Vatsa · Answer

yes use this when you change the checkbox mode (checked or unchecked). and store the result in db.

Mark Fenech · Answer

from where do i get the checkbox id :S ? as it is from datagridview

Abhimanyu K Vatsa · Answer

very easy do as directed. VB.NET: Dim result As byte result = Convert.ToByte(chkID.Checked) C#: byte result; result = Convert.ToByte(chkID.Checked); now store the result in DB.