spbase.cs

一个简单的聊天代码

using System;
using System.Data;
using System.Data.OleDb;
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;

/// <summary>
/// spbase 的摘要说明
/// </summary>
public class Spbase
{
    public Spbase()
    {
        //
        // TODO: 在此处添加构造函数逻辑
        //
    }

    public static string connstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Web.HttpContext.Current.Server.MapPath("~/App_Data/db1.mdb");

    public static DataSet GreatDs(string sql)
    {

        OleDbDataAdapter Dar = new OleDbDataAdapter(sql, connstring);

        DataSet ds = new DataSet();
        Dar.Fill(ds);

        return ds;
    }
    /// <summary>
    /// 
    /// </summary>
    /// <param name="sql"></param>
    public static void DoSql(string sql)
    {


        OleDbConnection conn = new OleDbConnection();//创建连接对象
        conn.ConnectionString = connstring;//给连接字符串赋值
        conn.Open();//打开数据库
        OleDbCommand cmd = new OleDbCommand(sql, conn);
        cmd.ExecuteNonQuery();//

        conn.Close();//关闭数据库

    }
    public static void Sy(string s)
    {
        
    }
    public  void DoSql2(string sql)
    {
        OleDbConnection conn = new OleDbConnection();//创建连接对象
        conn.ConnectionString = connstring;//给连接字符串赋值
        conn.Open();//打开数据库
        OleDbCommand cmd = new OleDbCommand(sql, conn);
        cmd.ExecuteNonQuery();//

        conn.Close();//关闭数据库
    }
}