Change in Form via ComboBox Selection

Question

Hello Friends,

I want to change my form instantly when I select an option in ComboBox.
For Example: If there is two text boxes for adding two integer and I select an option in combox
Box for string reverse so one textbox should remove instantly before I press any button.
Please help.

ThankYou.

Answer 1

If you are using sql server, all you have to do is, have a table variable with rows with all the required dates in that table.

The select from that table and left outer join (or cross join) with attendance table, you get the all the dates and null next to dates where there is no data.

Answer 2

Hi,<br><br> Please find the relative solution in sql-<br> http://marlonribunal.com/finding-gaps-in-or-missing-dates-using-tsql/<br><br> Also have a look at below threads for something similar done with linq-<br> http://stackoverflow.com/questions/1468637/filling-in-missing-dates-using-a-linq-group-by-date-query<br> http://stackoverflow.com/questions/35062144/find-missing-date-in-listdatetime-and-insert-that-date-on-the-right-index