ASP.NET 随笔

1. DropDownList操作

            DataTable dt = db.ExcSql("select  * from CTUSpeLine where FanWei !='主题'");
            ckListZX.DataSource = dt;
            ckListZX.DataTextField = "SpeName";
            ckListZX.DataValueField = "SpeID";
            ckListZX.DataBind();
            //为ListItem对象添加alt属性，值保存value值
            foreach (ListItem li in ckListZX.Items)
            {
                li.Attributes.Add("alt", li.Value);
            }

2.分页

首先下载最新的AspNetPager.dll，直接在vs中添加引用即可。

<%@ Register Assembly="UUPager" Namespace="UUPager" TagPrefix="cc1" %>

 

<cc1:AspNetPager ID="pager" runat="server" PageSize="36"  class="pager" AlwaysShow="True" NumericButtonCount="5">
</cc1:AspNetPager>

  int pageindex = 10;                    //默认页数
            int pagesize = 10;     //默认页记录数
            int ordertype = 0;
            DataTable dt = new DataTable();
            try
            {
                where += "and FanWei !='主题 '";
                pageindex = pager.CurrentPageIndex;
                pagesize = pager.PageSize;
                dt = db.Search_DT("CTUSpeLine", "and 1=1and FanWei !='主题 '", getFild, "SPEID", mian, ordertype, pagesize, pageindex, "", out PageCount, out Counts, 4);

                pager.RecordCount = Counts;
            }
            catch (System.Exception ex)
            {
                ClassUU.ClassAppLogs.WriteLogToLocalTextstatic(ex);
            }