class1.cs

来自「这是用asp做的一个实现投票和投票管理的小项目」· CS 代码 · 共 85 行

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;


/// <summary>
/// Class1 的摘要说明
/// </summary>
public class db: System.Web.UI.Page
{
	public db()
	{
		
	}
    
        public static OleDbConnection DBConnection()
        {
            return new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath("App_Data\\db1.mdb"));
        }
        public static DataTable select(string sql_sel)
    {

        OleDbConnection con = db.DBConnection();
        con.Open();
        OleDbCommand com = new OleDbCommand(sql_sel, con);
        DataSet ds = new DataSet();
        OleDbDataAdapter adapter = new OleDbDataAdapter();
        adapter.SelectCommand = com;

        adapter.Fill(ds);
        con.Close();
        return ds.Tables[0];


    }


        public static void execsql(string sql)
        { 
            OleDbConnection con = db.DBConnection();
            con.Open();
            OleDbCommand com = new OleDbCommand(sql, con);
            com.ExecuteNonQuery();
            con.Close();



        }
      


        public static DataTable ExecSel(string sql)
        {
            OleDbConnection conn = new OleDbConnection();
            conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Documents and Settings\\Administrator\\桌面\\asp1\\App_Data\\db1.mdb";
            conn.Open();
            OleDbCommand comm = new OleDbCommand(sql, conn);
            OleDbDataAdapter odaa = new OleDbDataAdapter();
            odaa.SelectCommand = comm;
            DataSet ds1 = new DataSet();
            odaa.Fill(ds1);
            conn.Close();
            return ds1.Tables[0];

        }
    public static string selone( string sql_votesum)
    {
        OleDbConnection con=db.DBConnection();
        con.Open();
        OleDbCommand com=new OleDbCommand(sql_votesum,con);
        return com.ExecuteScalar().ToString();  
        con.Close();

    }

    }