Hello friends ,to use sql server as backend.
firstly download the sql server 2005 and sql server management 2005.
when u open sql server management.
u find DATASOURCE NAME.->is already difine
LOGIN ID ->sa(SYSTEM ADMINISTRATION)
PASSWORD->any choose
After all info click on connect option.
Then appear a window ->then click on DATABASE->write down the name of data base->click ok->then a folder is appername has DATABASE name as u give->click on that name->appeasr the table->right click on table option->and creat our table (as u wish)and save the table with suitable information.
After that connectivity with suitable event(click button).
code is use.
try
{
SQLCONNECTION CN=NEW SQLCONNECTION();
connecton string="datasource=PERSONAL;USERID= ;password= ;
cn.open();
string sql="INSERT INTO tablename VALUES("@NAME,@EMAIL,@ADDRESS")";
SQLcommand cmd=new sqlcommand(sql,cn);
cmd.parameter.addwithvalue("name",txtname.text);
cmd.parameter.addwithvalue("email",txtemail.text);
cmd.parameter.addwithvalue("address",txtaddress.text);
cn.close
}
catch(exception s)
{
s.message();
}