Sometimes you need to know the value of your Primary Key when you insert record in your table. This is true if you have a Master/Detail form and you need to know the Primary key value of the parent table so that you can insert rows in the related table.
Consider the following scenario:
Just want to share with you on how to concatenate or combine one or more values from multiple rows. This SQL code is part of my “Online Hotel Reservation” project.
The idea here is to group column values while concatenating the other column to avoid duplicate records.
Here’s an example:
I have the following record on my table:
Switch Statement is the same as If…Else Statements except that it is easier to use if you have multiple conditions.
Switch Syntax
Sometimes we need to store some data or files under %appdata%. If you are using Windows 7 you can find this folder under C:\Users\Username\AppData.
AppData is a folder used to store information like cookies, Libraries, program settings, temporary files, templates, etc.
By using this folder you are certain that your settings are being protected by Windows.
To access this folder, all you have to do is use the following code: