default.aspx.cs

一个简单的新闻发布系统,入门最好先学这个

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;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //确认网页不是回滚
        if (!IsPostBack)
        {
            
            //建立数据连接
            string strConnnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
            strConnnection += Server.MapPath(".\\App_Data\\news.mdb");
            OleDbConnection myconn = new OleDbConnection(strConnnection);
            //创建OleDbDataAdapter对象，按照指定的查询语句获取结果
            OleDbDataAdapter mycmd1 = new OleDbDataAdapter("select top 12 contents.* from contents where typeid=1 order by shijian desc",myconn);

            OleDbDataAdapter mycmd2 = new OleDbDataAdapter("select top 12 contents.* from contents where typeid=2 order by shijian desc",myconn);
           //定义DataSet对象，将查询结果填充到这个对象上
            DataSet ds = new DataSet();

            mycmd1.Fill(ds,"contents");
            mycmd2.Fill(ds,"types");
            //将DataSet对象绑定到GridView上
            this.GridView1.DataSource = ds.Tables["contents"].DefaultView;
            this.GridView2.DataSource = ds.Tables["types"].DefaultView;

            this.GridView1.DataBind();
            this.GridView2.DataBind();


        
        }
    }
}