ASP.NET(C#)与SQL Server2000如何连接？

Question

主要是连接字符串：
Standard Security
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

Answer 1

private static void OpenSqlConnection()
{
    string connectionString = GetConnectionString();
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        connection.Open();
        Console.WriteLine("ServerVersion: {0}", connection.ServerVersion);
        Console.WriteLine("State: {0}", connection.State);
    }
}static private string GetConnectionString()
{
    // To avoid storing the connection string in your code, 
    // you can retrieve it from a configuration file, using the 
    // System.Configuration.ConfigurationSettings.AppSettings property 
    return "Data Source=(local);Initial Catalog=AdventureWorks;"
        + "Integrated Security=SSPI;";
}

Answer 2

ConnectionString="server=.;database=pubs;uid=sa;pwd=;"

Answer 3

http://www.baidu.com/s?wd=asp.net%C1%AC%BD%D3sql&cl=3

Answer 4

SqlConnection conn = new SqlConnection("server=zwl;database=login;uid=sa;pwd=admin;")
conn.open();
SqlCommand = new SqlCommand("select count(*) from login where userName =""+userName+"" and userPwd=""+userPwd+"",conn);
int count=Convert.ToInt32(cmd.ExecuteScalar());
//ExecuteScalar()执行查询并返回所查询结果集的第一行第一列
if(count>0){
　 Response.Redirect("main.aspx");
}　else {
　 Response.Redirect("error.aspx");
}

Answer 5

SqlConnection conn = new SqlConnection("server=.;database=pubs;uid=sa;pwd=;");
conn.open();

Answer 6

用SqlDataSource啊,和2005是一样的,只不过数据库设计方面有点差别

Answer 7

luck0235(风平浪静时人人都能掌舵) 
难怪好多程序员的薪水不如民工，看到楼主这帖我算是明白了...------------------------------------------------------------------------
........

Answer 8

SqlConnection conn = new SqlConnection("server=zwl;database=login;uid=sa;pwd=admin;")
conn.open();
SqlCommand = new SqlCommand("select count(*) from login where userName =""+userName+"" and userPwd=""+userPwd+"",conn);
int count=Convert.ToInt32(cmd.ExecuteScalar());
//ExecuteScalar()执行查询并返回所查询结果集的第一行第一列
if(count>0){
　 Response.Redirect("main.aspx");
}　else {
　 Response.Redirect("error.aspx");
}