what is the use of get and set properties in c#

Question

I would like to know the use of set and get properties in c#.net and how you use it with databases;
please demonstrate with examples

donwany