Hi,
try this link to get much information about the topic:
www.microsoft.com/sqlserver/2005/en/us/java-database-connect­ivity.aspx

I want to know the full process of creating database connectitivity with sql server and asp.net 2005

Hello All,
If anyone want to take help for free just call +92 312 96 94 100.

--
Naina " redy 2 solve ur prob"


hey i think u shuld use ado.net for connectivity in c# . by this way u can connect database

Hello If anyone want help just call at +92 312 96 94 100.
Thanks & Regards.
M. Ammar Afzal.

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();
}