基本ADO.NET知识

SQLServer连接字符串：
1."Server={server instance};
  AttachDbFilename={directory path}\Northwind.mdf;Database=Northwind;Trusted_Connection=Yes;"
2."Server={server instance};
  AttachDbFilename=|DataDirectory|Northwind.mdf;Database=Northwind;Trusted_Connection=Yes;"
 
  Integrated Security=True;Integrated Security=SSPI;

Data Source={server instance};Initial Catalog=Northwind;User Id=sa;Password=****;"
   - or -
"Server={server instance};Database=Northwind;User ID=sa;Password=*****;Trusted_Connection=False"
 

 SqlConnection conn = new SqlConnection
                    (@"Server=WJH"SQL2005;AttachDbFilename=C:"Program Files"Microsoft SQL Server"MSSQL.1"MSSQL"Data"FrameWork.mdf;Database=FrameWork;Trusted_Connection=Yes;");
               SqlDataAdapter adp = new SqlDataAdapter("SELECT * FROM sys_Event", conn);
               DataSet ds = new DataSet();
               adp.Fill(ds);
              
conn.Open();

            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "select * from student";
            SqlDataReader reader = cmd.ExecuteReader();

            while(reader.Read())
            {
            }
            reader.Close();
            conn.Close();

   conn.Open();

            cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "Update student set city = 'beijing'where id = @id" ;
            SqlParameter id = new SqlParameter(id,SqlDbType.Int);
            id.Value = Convert.ToInt32(this.textBox1.Text);

            cmd.ExecuteNonQuery();
            conn.Close();