简单操作数据库的类

来源：互联网发布：通达信筹码分布源码编辑：程序博客网时间：2024/06/05 06:53

//简单操作数据库的类,包括查询、添加、修改、删除
using System;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;

public class DataAccess
{
public string SqlBase="server=127.0.0.1;database=pubs;uid=sa;password=sa";//修改127.0.0.1为你MSSQL服务器地址，pubs为你的数据库名称，sa为MSSQL帐号，还有密码！
    public DataTable DisPlayList_Dt(string sql,SqlConnection conn)//返回DATATABLE类型的数据集
{
        DataTable Dt = new DataTable();
        SqlDataAdapter ShowAdapter = new SqlDataAdapter(sql, conn);
        ShowAdapter.Fill(Dt);
        conn.Close();
        return Dt;
}
    public DataSet DisPlayList_Ds(string sql, SqlConnection conn)//返回DATASET类型的数据集
    {
        DataSet Dt = new DataSet();
        SqlDataAdapter ShowAdapter = new SqlDataAdapter(sql, conn);
        ShowAdapter.Fill(Dt);
        conn.Close();
        return Dt;
    }
    public int AddInfo(string sql, SqlConnection conn)//添加记录，成功返回1，失败返回0
    {
        int State;
        try
        {
            SqlCommand AddInfoCmd = new SqlCommand(sql, conn);
            AddInfoCmd.ExecuteNonQuery();
            conn.Close();
            State = 1;
        }
        catch
        {
            State=0;
            conn.Close();
        }
        return State;
    }
    public int DelInfo(string sql, SqlConnection conn)//删除记录，成功返回1，失败返回0
    {
        int State;
        try
        {
            SqlCommand AddInfoCmd = new SqlCommand(sql, conn);
            AddInfoCmd.ExecuteNonQuery();
            conn.Close();
            State = 1;
        }
        catch
        {
            State = 0;
            conn.Close();
        }
        return State;
    }
    public int ModInfo(string sql, SqlConnection conn)//修改记录，成功返回1，失败返回0
    {
        int State;
        try
        {
            SqlCommand AddInfoCmd = new SqlCommand(sql, conn);
            AddInfoCmd.ExecuteNonQuery();
            conn.Close();
            State = 1;
        }
        catch
        {
            State = 0;
            conn.Close();
        }
        return State;
    }
}

//使用实例

            DataAccess lj = new DataAccess();
            SqlConnection conn = new SqlConnection(lj.SqlBase);
            conn.Open();
            DataTable GetUserInfoDt = lj.DisPlayList_Dt("Select * from PE_User where UserName='" + tbName.Text + "'and UserPassword='" + pass + "'and GroupID>1", conn);
            int CheckNum = GetUserInfoDt.Rows.Count;
            if (CheckNum == 1)
            {
                Session["AdminName"] = tbName.Text;
                Session["GroupID"] = "2";
                Response.Redirect("manager_manager.aspx");
            }
            else
            {
                Response.Write("<script>alert('登陆失败！');</script>");
            }