ASP.NET的数据库基本访问

1.连接SQL数据库   
    

SqlConnection conn = new SqlConnection();
	//Integrated Security:true时用windows账号验证，false用ID和密码验证。
	//Data Source：连接到的计算机或IP，填"."或localhost代表本地。Initial Catalog：数据库名称
    conn.ConnectionString = "Integrated Security=True;Data Source=.;Initial Catalog=Sample_DB;User ID=sa;Password=003024mao;";
    conn.Open();  //打开
    if (conn.State == ConnectionState.Open) //验证是否连接上SQL Server
      {
        Label1.Text = "当前数据库已连接<br/>";
        Label1.Text += "连接字符串为：" + conn.ConnectionString;
      }
	  
		//连接字符串的可以写在web.config中
		<connectionStrings>
			<add name ="string" connectionString="Data Sourse=localhost";Initial Catalog=Northwind;Integrated Security=true/>
		</connectionStrings>
		//并在c#中作出如下调用
		WebConfiguretionManager.ConnectionStrings["string"].ConnectionString;
	  

2.操作数据库
       

 SqlCommand cmd = new SqlCommand();     
        SqlDataReader dr;
        cmd.CommandText = "";      // SELECT语句
        cmd.Connection = conn;		
        cmd.CommandTimeout = 5;
        dr = cmd.ExecuteReader();
        while (dr.Read())
        {
        }
		 dr.Close();
        conn.Close();