Friday, 21 December 2012 13:51

how to Use View tables in Sql server

if we need some fields from different tables
temporarily in our software or application then

Published in database
Wednesday, 19 December 2012 13:55

how to attach and detach databases in sql server

connecting local MDF database files to sql
server management studio express is easy to do.
following are the steps to do so -

Published in database

It's a good idea to use a class say gateway where all
database access codes will be this gateway class
you will implement db connection as follows -

first create another class -

Published in database