class1.cs

关于ASP.NET制作程序模块

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Collections;


/// <summary>
/// Class1 的摘要说明
/// </summary>
public class Class1
{
    public Class1()
    {
        //
        // TODO: 在此处添加构造函数逻辑
        //
    }
         //获取state集合。返回IEnumerable，并通过DropDownList显示
    public static IEnumerable GetStates()
    {
        //获取连接字符串
        string connectionString = ConfigurationManager.ConnectionStrings["connectiondb"].ConnectionString;
        //定义SQL查询语句
        string cmdtext = "Select distinct state from authors";
        //创建并设置SqlDataSource
        SqlDataSource sqlDS = new SqlDataSource(connectionString, cmdtext);
        sqlDS.DataSourceMode = SqlDataSourceMode.DataSet;
        //返回数据
        return sqlDS.Select(DataSourceSelectArguments.Empty);
    }

    //根据state参数，获取数据记录。返回DataView，并通过GridView显示
    public static DataView GetAuthorsByState(string state)
    {
        //获取连接字符串
        string connectionString = ConfigurationManager.ConnectionStrings["connectiondb"].ConnectionString;
        //定义SQL查询语句
        string cmdtext = "Select au_id,au_fname,au_lname,state from authors where state=@state";
        //创建并设置SqlDataSource及其参数
        SqlDataSource sqlDS = new SqlDataSource(connectionString, cmdtext);
        sqlDS.DataSourceMode = SqlDataSourceMode.DataSet;
        sqlDS.SelectParameters.Clear();
        //设置和添加参数@state
        Parameter state1 = new Parameter("state", TypeCode.String, state);
        sqlDS.SelectParameters.Add(state1);
        //返回数据，并将IEnumerable转换为DataView类型
        return (DataView)sqlDS.Select(DataSourceSelectArguments.Empty);
    }

    //更新数据记录
    public static int UpdateAuthor(string au_id, string au_lname, string au_fname, string state)
    {
        //获取连接字符串
        string connectionString = ConfigurationManager.ConnectionStrings["connectiondb"].ConnectionString;
        //定义SQL查询语句
        string cmdtext = "UPDATE authors SET au_fname=@au_fname, au_lname=@au_lname, state=@state WHERE au_id = @au_id";
        //创建并设置SqlDataSource
        SqlDataSource sqlDS = new SqlDataSource();
        sqlDS.ConnectionString = connectionString;
        sqlDS.UpdateCommand = cmdtext;
        sqlDS.DataSourceMode = SqlDataSourceMode.DataSet;
        sqlDS.UpdateParameters.Clear();
        //设置和添加参数@au_lname
        Parameter lname = new Parameter("au_lname", TypeCode.String, au_lname);
        sqlDS.UpdateParameters.Add(lname);
        //设置和添加参数@au_fname
        Parameter fname = new Parameter("au_fname", TypeCode.String, au_fname);
        sqlDS.UpdateParameters.Add(fname);
        //设置和添加参数@state
        Parameter state1 = new Parameter("state", TypeCode.String, state);
        sqlDS.UpdateParameters.Add(state1);
        //设置和添加参数@au_id
        Parameter id = new Parameter("au_id", TypeCode.String, au_id);
        sqlDS.UpdateParameters.Add(id);
        //返回受影响的行数
        return sqlDS.Update();
    }
}