Want to display same date regardless of whether employee has a deferral or not.

Question

I want to retrieve a pay date from say PayRoll table called PayrollDate.
For this I would like to display the same Payroll date for all employees regardless of whether the employee has had a deferral or not. How would I go about this.
I have been dabbling in Case Satements, but I still get null values...
Any help?
 

Answer 1

Hi coders. I have discovered my problem but are appears another very related doubt. I recreated the database directly into the Management Studio, not by adding a New Item to my project, the rest was the same and the changes were comitted and seved to the database. Here the upcoming doubt: Why the TableAdapter.Update method works when the database is residing on the server and not locally in my project? This problem is related with the created instance of the local database at runtime? Thanks Jorge L.