DataSet的使用(一)

 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 Family
/// </summary>
public class Family
{
    private readonly string _conStrings;
    public Family()
    {
        _conStrings=WebConfigurationManager.ConnectionStrings["CNPCEditConnectionStrings"].ConnectionString;
        //
        // TODO: Add constructor logic here
        //
    }

    //获取Family列表
    public DataSet GetFamily()
    {
        //创建连接
        SqlConnection con = new SqlConnection(_conStrings);

        //创建命令
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        string CommandText = "select FamilyID as 科号, FamilyNameCh as 科中文名 from Family";

        //返回DataSet对象

        SqlDataAdapter sdr=new SqlDataAdapter(CommandText,_conStrings);
        DataSet myds=new DataSet();
        using (sdr)
        {            
            sdr.Fill(myds);
        }
        return myds;        
    }

    //更新Family
    public void UpdateFamily(int familyid, string familynamech)
    {
        //创建命令
        SqlConnection con = new SqlConnection(_conStrings);
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "update family set FamilyID=@FamilyID, FamilyNameCh=@FamilyNameCh where FamilyID=@FamilyID";

        //增加参数
        cmd.Parameters.AddWithValue("@FamilyID", familyid);
        cmd.Parameters.AddWithValue("@FamilyNameCh", familynamech);


        //执行命令
        using (con)
        {
            con.Open();
            cmd.ExecuteNonQuery();
        }
    }
}