default.aspx.cs

包含了几个由sql server2005开发的典型程序

///using System;
///using System.Data;
///using System.Configuration;
///using System.Collections;
///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;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using GROUP.Manage;



public partial class _Default : System.Web.UI.Page
{

    BaseClass BaseClass1 = new BaseClass();

    protected void Page_Load(object sender, EventArgs e)
    {
        // 在此处放置用户代码以初始化页面
        string strsql;
        strsql = "SELECT top 6 流水号,新闻标题,添加时间  FROM 新闻信息 where 新闻类别='企业新闻' order by 流水号 desc ";
        DataTable dt = BaseClass1.ReadTable(strsql);
        GridView1.DataSource = dt;
        GridView1.DataBind();

        strsql = "SELECT top 6 流水号,新闻标题,添加时间  FROM 新闻信息 where 新闻类别='业内新闻' order by 流水号 desc ";
        dt = BaseClass1.ReadTable(strsql);
        GridView2.DataSource = dt;
        GridView2.DataBind();

        strsql = "select top 4 * from 产品 order by 流水号 ";
        dt = BaseClass1.ReadTable(strsql);
        DataList1.DataSource = dt;
        DataList1.DataBind();
    }
    protected void Head1_Load(object sender, EventArgs e)
    {

    }
}