pagelefter.ascx.cs

大家一起研究研究,全部都是开源的CSHARP代码.带数据库的

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

public partial class PageLefter : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string sql = "select top 5 * from [ncproducts] Where [ProductCmd]=1 order by [productid] desc";
        WebConfig.CreateCon();
        OleDbDataAdapter da = new OleDbDataAdapter(sql, WebConfig.con);
        DataSet ds = new DataSet();
        da.Fill(ds);
        this.Repeater1.DataSource = ds.Tables[0];
        this.Repeater1.DataBind();
        
        string sql1="select top 5 * from [ncnews] where [newsclassid]=2 order by [newsid] desc";
        da = new OleDbDataAdapter(sql1, WebConfig.con);
        da.Fill(ds);
        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
            if (ds.Tables[0].Rows[i]["NewsTitle"].ToString().Length > 12)
            {
                ds.Tables[0].Rows[i]["NewsTitle"] = ds.Tables[0].Rows[i]["NewsTitle"].ToString().Substring(0,12) + "...";
            }
        }
        this.Repeater2.DataSource = ds.Tables[0];
        this.Repeater2.DataBind();
    }
}