default.aspx.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 _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        this.Head1.Title = "首页--"+Application["WebName"].ToString();
        string sql = "select top 3 * from [ncnews] where [newsclassid]=1 and [NewsPic]<>'' order by [newsid] desc";
        WebConfig.CreateCon();
        OleDbDataAdapter da = new OleDbDataAdapter(sql, WebConfig.con);
        DataSet ds = new DataSet();
        da.Fill(ds);
        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
            if (ds.Tables[0].Rows[i]["NewsTitle"].ToString().Length > 16)
            {
                ds.Tables[0].Rows[i]["NewsTitle"] = ds.Tables[0].Rows[i]["NewsTitle"].ToString().Substring(0, 16) + "...";
            }
        }
        this.Repeater1.DataSource = ds.Tables[0];
        this.Repeater1.DataBind();

        sql = "select top 8 * from [ncnews] where [newsclassid]=1 and [isindexshow]<>1 order by [newsid] desc";
        da = new OleDbDataAdapter(sql, 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 > 10)
            {
                ds.Tables[0].Rows[i]["NewsTitle"] = ds.Tables[0].Rows[i]["NewsTitle"].ToString().Substring(0, 10) + "...";
            }
        }
        this.Repeater2.DataSource = ds.Tables[0];
        this.Repeater2.DataBind();

        string sql3 = "select top 8 * from [NcProducts] Order By [ProductId] DESC";
        OleDbDataAdapter da3 = new OleDbDataAdapter(sql3, WebConfig.con);
        DataSet ds3 = new DataSet();
        da3.Fill(ds3);
        DataTable dt = ds3.Tables[0];
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            if (dt.Rows[i]["ProductName"].ToString().Length > 8)
            {
                dt.Rows[i]["ProductName"] = dt.Rows[i]["ProductName"].ToString().Substring(0, 8);
            }
            if (dt.Rows[i]["ProductPic"] != null)
            {
                if (dt.Rows[i]["ProductPic"].ToString() != "")
                {
                    dt.Rows[i]["ProductPic"] = "upload/" + dt.Rows[i]["ProductPic"].ToString();
                }
                else
                {
                    dt.Rows[i]["ProductPic"] = "images/no_pic.gif";
                }
            }
            else
            {
                dt.Rows[i]["ProductPic"] = "images/no_pic.gif";
            }
        }

        Repeater3.DataSource = dt;
        Repeater3.DataBind();


        string sql4 = "select top 3 A.*,B.[ClassName] from [NcProducts] A Left Join [NcClass] B On A.[ProductCLassId]=b.[ClassId] Order By A.[ProductId] DESC";
        OleDbDataAdapter da4 = new OleDbDataAdapter(sql4, WebConfig.con);
        DataSet ds4 = new DataSet();
        da4.Fill(ds4);
        dt = ds4.Tables[0];
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            if (dt.Rows[i]["ProductName"].ToString().Length > 8)
            {
                dt.Rows[i]["ProductName"] = dt.Rows[i]["ProductName"].ToString().Substring(0, 8);
            }
            if (dt.Rows[i]["ProductPic"] != null)
            {
                if (dt.Rows[i]["ProductPic"].ToString() != "")
                {
                    dt.Rows[i]["ProductPic"] = "upload/" + dt.Rows[i]["ProductPic"].ToString();
                }
                else
                {
                    dt.Rows[i]["ProductPic"] = "images/no_pic.gif";
                }
            }
            else
            {
                dt.Rows[i]["ProductPic"] = "images/no_pic.gif";
            }
        }

        Repeater4.DataSource = dt;
        Repeater4.DataBind();

    }
}