database.cs

数据绑定采用GridView控件

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.OleDb;
//该源码下载自www.51aspx.com(５１asｐｘ．ｃｏｍ)

/// <summary>
/// DataBase 的摘要说明
/// </summary>
public class DataBase
{
    static  string constr = "Provider=Microsoft.Jet.OLEDB.4.0;data source="+HttpContext.Current.Server.MapPath("~/App_Data/book.mdb");
    OleDbConnection conn = new OleDbConnection(constr);
	public DataBase()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    public Boolean ExecSQl(string QueryString) 
    {
        
        conn.Open();
        OleDbCommand comm = new OleDbCommand(QueryString,conn);
        try
        {
            comm.ExecuteNonQuery();
        }
        catch (System.Exception x)
        {
            throw x;
            
        }
        finally 
        {
            conn.Close();
        }
        return true;
    }
    public System.Data.DataSet GetDataSet(string QueryString,string TableName) 
    {
        OleDbDataAdapter da = new OleDbDataAdapter(QueryString,conn);
        DataSet ds = new DataSet();
        da.Fill(ds,TableName);
        return ds;
    }
   
    public int CheckLogin(string loginName, string loginPwd)
    {
        string sql = "select count(*) from admin where username=? and userpwd=?";
        OleDbConnection conn = new OleDbConnection(constr);
        OleDbCommand comm = new OleDbCommand(sql, conn);
        //comm.CommandType = CommandType.StoredProcedure;
        OleDbParameter p1 = new OleDbParameter("?",OleDbType.VarWChar,50);
        p1.Value = loginName;
        comm.Parameters.Add(p1);
        OleDbParameter p2 = new OleDbParameter("?",OleDbType.VarWChar,50);
        p2.Value = loginPwd;
        comm.Parameters.Add(p2);
        comm.Connection.Open();
        int i = (int)comm.ExecuteScalar();
        comm.Connection.Close();
        return i;
      
    }
}