*DAL层常用 读取 写入 代码

 1 ///summey
 2 ///读取
 3 ///summey
 4 DataSet ds = new DataSet();
 5             SqlConnection conn = new SqlConnection(connString);
 6             SqlDataAdapter objAdapter = new SqlDataAdapter(dboOwner + ".usp_SelectStudentsPartInfo", conn);
 7             objAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
 8             objAdapter.Fill(ds, "studentTable");
 9             conn.Close();
             conn.Dispose();
             return ds;
           
 ///summey  
 ///写入
 ///summey
 SqlConnection conn = new SqlConnection(connString);
             SqlCommand objCommand = new SqlCommand(dboOwner + ".usp_InsertClass", conn);
             objCommand.CommandType = CommandType.StoredProcedure;
             objCommand.Parameters.Add("@ClassName", SqlDbType.NVarChar, 50).Value = dsClass.Tables["Class"].Rows[0]["ClassName"];
             objCommand.Parameters.Add("@GradeID", SqlDbType.Int).Value = dsClass.Tables["Class"].Rows[0]["GradeID"];
             conn.Open();
             objCommand.ExecuteNonQuery();
             conn.Close();
             conn.Dispose();