logging in
database (11)
Sql server knows many data types.it's worth our
while to know most common types -
how to backup sql server database using SMO in asp.net
Written by Super Userusing 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.
stored procedures allow flexibility by offering capabilities like
conditional logic.a single procedure may execute a set of SQL
statements which are really complex.
if we need some fields from different tables
temporarily in our software or application then
MySQL provides drivers for .Net enabling building database
applications by their appropriate languages.
Database connection implementation using function & xml file
Written by Super UserIt'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 -
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 -
using connectionstring of configuration file in pages
Written by Super Usernormally 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?.
how to publish database file as a script file with data
Written by Super User
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 -