注册 登录
编程论坛 ASP.NET技术论坛

怎么调用类文件

雪夜白狼 发布于 2008-05-05 15:47, 1263 次点击
我在我的站点中定义了一个db.cs类文件怎么在页面中调用呢?
例如:

public class DB:System.Web.UI.Page
{
    public DB()
    {
        //
        // TODO: 在此处添加构造函数逻辑
        //
    }
    public static OleDbConnection DBconntion()
    {
        OleDbConnection conn = new OleDbConnection();
        conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+HttpContext.Current.Server.MapPath("app_data/it.mdb");
        return conn;
    }
    public static DataTable DBtable(string sql)
    {
        OleDbConnection conn = new OleDbConnection();
        conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath("app_data/it.mdb");
        conn.Open();
        OleDbCommand comm = new OleDbCommand(sql,conn);
        OleDbDataAdapter da = new OleDbDataAdapter();
        da.SelectCommand = comm;
        DataSet ds = new DataSet();
        da.Fill(ds);
        conn.Close();
        return ds.Tables[0] ;
    }
}


怎么在后边调用它呢?

 
    OleDbConnection conn;
    OleDbCommand DBtable;
    protected void Page_Load(object sender, EventArgs e)
    {
        conn = DB.DBconntion();
        conn.Open();
        //OleDbConnection conn = new OleDbConnection();
        //conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("app_data/it.mdb");
        //conn.Open();


        string sql = "select * from zx";
        DB dt = new DB();
        DataTable dts = DB.DBtable();
        
        
      
        //OleDbCommand comm = new OleDbCommand(sql, conn);
        //OleDbDataAdapter da = new OleDbDataAdapter();
        //da.SelectCommand = comm;
        //DataSet ds = new DataSet();
        //da.Fill(ds);
        //conn.Close();


        DataList1.DataSource =dts;
        DataList1.DataBind();
    }
这样写的话红色的部分报错!!
要怎么写呢?
4 回复
#2
hebingbing2008-05-05 17:19
1.你的类文件是不是DB.cs还是db.cs,
2.你调用的时候是不是没有调用参数啊……
#3
kevintang2008-05-06 09:22
string sql = "select * from zx";
        DB dt = new DB();
        DataTable dts = DB.DBtable(sql );
#4
yms1232008-05-07 15:25
楼主的两个类文件是在同一个命名空间下?
#5
雪夜白狼2008-05-07 17:42
没有学过面向对象的编程语言
刚开始学习.net所以很多不懂的地方
谢谢大家的回复!!
1