database

database (10)

Rate this item
(0 votes)

using SMO classes one can backup a sql server database
in .bak extension.It's a programming approach to backup
database.there are other ways but using SMO classes it
is efficient and error free.

Friday, 28 December 2012 13:55

common sql server data types explained

Written by
Rate this item
(0 votes)

Sql server knows many data types.it's worth our
while to know most common types -

Monday, 24 December 2012 13:55

stored procedures

Written by
Rate this item
(0 votes)

stored procedures allow flexibility by offering capabilities like
conditional logic.a single procedure may execute a set of SQL
statements which are really complex.

Saturday, 19 January 2013 13:56

how to read from a xml file

Written by
Rate this item
(0 votes)
suppose you have some data in the xml file as shown -
Sunday, 30 December 2012 13:54

using MYSQL database in asp.net website

Written by
Rate this item
(0 votes)

MySQL provides drivers for .Net enabling building database
applications by their appropriate languages.

Sunday, 13 January 2013 14:56

how to backup database file of your application

Written by
Rate this item
(0 votes)

you should backup your database file of your
windows software.there are many reasons why you
will backup your database file.i will not write
details about that.i showing here how to
backup your database file for safety of your
database -

Friday, 21 December 2012 13:51

how to Use View tables in Sql server

Written by
Rate this item
(0 votes)

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

Rate this item
(0 votes)

normally we define connectionstrings under
<connectionStrings> tag in the web.config
file.membership providers use that
connectionstring.what if we needed to use
the connectionstring in asp.net pages?.

Rate this item
(0 votes)

If you want to publish your database from one database
server to another,sql server database publishing
wizard can do that.without downloading it you can
use visual studio to publish your db as .sql script
file.then you can run this script file in another
sql server to get the database with all tables and data.
I show you how -

Rate this item
(0 votes)

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

first create another class -