C# SQL Server2000解决方法

C# SQL Server2000
C#   怎样连接   SQL   Server2000?谢谢

[解决办法]
SqlConnection conn=new SqlConnection(连接字符串);
[解决办法]
一般在web.config中设置:
<add key= "connstring " value= "Data Source=(local);user id=sa;pwd=123;Initial Catalog=guestbook;Integrated Security=False "/>

读取的时候:
string connsql= ConfigurationSettings.AppSettings[ "connstring "];