student 类库

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web.UI.WebControls;

/// <summary>
///student 的摘要说明
/// </summary>
public class student
{
    private string strCnn;
 public student()
 {
  //
  //TODO: 在此处添加构造函数逻辑
  //
        strCnn = ConfigurationManager.ConnectionStrings["studentConnectionString"].ConnectionString;

 }
    public int SID { get; set; }
    public string SName { get; set; }
    public string Sex { get; set; }
    public string Photo { get; set; }
    public DataTable StudentSelect()
    {
        DataSet ds = new DataSet();
        using (SqlConnection sqlcnn = new SqlConnection(strCnn))
        {
            SqlCommand sqlcmm = sqlcnn.CreateCommand();
            sqlcmm.CommandText = "select sid,sname,sex,photo from student";
            SqlDataAdapter da = new SqlDataAdapter(sqlcmm);
            da.Fill(ds);

        }
        return ds.Tables[0];
    }
    public void StudentDelete(int sid)
    {
        using (SqlDataSource sds = new SqlDataSource())
        {
            sds.DeleteCommand = "delete from student where sid=@sid";
            sds.DeleteParameters.Add("sid", sid.ToString());
            sds.ConnectionString = strCnn;
            sds.Delete();
        }
    }
    public List<student> GetStudents()
    {
        DataSet ds = new DataSet();
        using (SqlConnection sqlcnn = new SqlConnection(strCnn))
        {
            SqlCommand sqlcmm = sqlcnn.CreateCommand();
            sqlcmm.CommandText = "select sid,sname,sex,photo from student";
            SqlDataAdapter da = new SqlDataAdapter(sqlcmm);
            da.Fill(ds);
        }
        List<student> list = new List<student>();
        foreach (DataRow row in ds.Tables[0].Rows)
        {
            //list.Add(new  Student{ SID = (int)row["sid"], SName = row["sname"].ToString(), Sex = row["sex"].ToString(), Photo = row["photo"].ToString()});
            student st = new student();
            st.SID = (int)row["sid"];
            st.SName = row["sname"].ToString();
            st.Sex = row["sex"].ToString();
            st.Photo = row["photo"].ToString();
            list.Add(st);
        }
        return list;
    }
    public void StudentUpdate(int sid,string sname,string sex,string photo)
    {
        using (SqlDataSource sds = new SqlDataSource())
        {
            sds.UpdateCommand = "update student set sname=@sname,sex=@sex,photo=@photo where sid=@sid";
            sds.UpdateParameters.Add("sid", sid.ToString());
            sds.UpdateParameters.Add("sname", sname);
            sds.UpdateParameters.Add("sex", sex);
            sds.UpdateParameters.Add("photo", photo);
            sds.ConnectionString = strCnn;
            sds.Update();
        }
    }
   
}