ObjectDataSource的使用(一)

 1using System;
 2using System.Collections.Generic;
 3using System.Linq;
 4using System.Web;
 5using System.Data;
 6using System.Data.SqlClient;
 7using System.Web.Configuration;
 8
 9/**//// <summary>
/// Summary description for FamilyData
/// </summary>
public class FamilyData
{
    private readonly string _conStrings;
    public FamilyData()
    {
        _conStrings = WebConfigurationManager.ConnectionStrings["CNPCEditConnectionStrings"].ConnectionString;
        //
        // TODO: Add constructor logic here
        //
    }
    public class FamilyName
    {
        private int _FamilyID;
        public int FamilyID
        {
            get { return _FamilyID; }
            set
            {
                _FamilyID = value;
            }
        }
        private string _FamilyName;
        public string FamilyNamex
        {
            get { return _FamilyName; }
            set
            {
                _FamilyName = value;
            }
        }
        private string _FamilyNameCh;
        public string FamilyNameCh
        {
            get { return _FamilyNameCh; }
            set
            {
                _FamilyNameCh = value;
            }
        }        
    }
    public List<FamilyName> GetFamilyName()
    {
        List<FamilyName> name = new List<FamilyName>();
        SqlConnection con = new SqlConnection(_conStrings);
        SqlCommand cmd = new SqlCommand();        
        cmd.CommandText = "Select FamilyID, FamilyName, FamilyNameCh from Family";
        cmd.Connection = con;
        using (con)
        {
            con.Open();
            SqlDataReader sdr = cmd.ExecuteReader();
            while (sdr.Read())
            {
                FamilyName newName = new FamilyName();
                newName.FamilyID = (int)sdr["FamilyID"];
                newName.FamilyNamex = (string)sdr["FamilyName"];
                newName.FamilyNameCh= (string)sdr["FamilyNameCh"];
                name.Add(newName);
            }
        }
        return name; 
    }
    public void UpdateFamily(FamilyName familyToUpdate)
    {
        SqlConnection con = new SqlConnection(_conStrings);
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = "update Family set FamilyName=@FamilyName, FamilyNameCh=@FamilyNameCh where FamilyID=@FamilyID ";
        cmd.Connection = con;
        cmd.Parameters.AddWithValue("@FamilyID", familyToUpdate.FamilyID);
        cmd.Parameters.AddWithValue("@FamilyName", familyToUpdate.FamilyNamex);
        cmd.Parameters.AddWithValue("@FamilyNameCh", familyToUpdate.FamilyNameCh);
        using (con)
        {
            con.Open();
            cmd.ExecuteNonQuery();
        }

    }
}