vendredi 2 septembre 2016

Checkbox Value/Add Column and Update command in MYSQL using Datagridview

Good Afternoon.

Im having a hard time thinking how to make a program using this features and looking forward that someone help me here. anyway TY in advance.

I am preparing to create a table that will look like this.

enter image description here

Please be guided that the yellow colored rows are the the fields in MYSQL (Column Header)

Here is my Question.

  1. How can I insert another field in my table? lets say I will add a new field called 2004 how can i make it?
  2. How can I display all year columns with a Checkbox in Datagridview? like this

enter image description here

  1. How can I update my table using that datagridview? example in the image at the top I checked the January and 2001 like

Update PeriodClosure set 2001 = True where Month = 'Datagridviw(Checkbox)' and 2001 = 'Datagridviw(Checkbox)'

Im just exampling the year 2001.

  1. And lastly this, I have a datetimepicker in my program in short format and How can I use that datetimepicker to select if the selected month and year is True or False in the table.

Sorry for many question because this is my first time doing this. TYSM




Aucun commentaire:

Enregistrer un commentaire