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.
Please be guided that the yellow colored rows are the the fields in MYSQL (Column Header)
Here is my Question.
- How can I insert another field in my table? lets say I will add a new field called
2004
how can i make it? - How can I display all year columns with a Checkbox in Datagridview? like this
- How can I update my table using that datagridview? example in the image at the top I checked the
January
and2001
like
Update PeriodClosure set 2001 = True where Month = 'Datagridviw(Checkbox)' and 2001 = 'Datagridviw(Checkbox)'
Im just exampling the year 2001.
- 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