<![CDATA[风之相随'S BLOG - ASP.net C#]]> http://www.windsfly.cn/blog/ zh-cn PBlog2 v2.4 风之相随'S BLOG http://www.windsfly.cn/blog/images/logos.gif http://www.windsfly.cn/blog/ 风之相随'S BLOG http://www.windsfly.cn/blog/default.asp?id=2017 <![CDATA[GridView、Repeater等数据控件列数字、货币和日期的显示格式]]> sf223cn@yahoo.com.cn(admin) Tue,31 Aug 2010 21:42:25 +0800 http://www.windsfly.cn/blog/default.asp?id=2017
形式 语法 结果 注释
数字 {0:N2} 12.36  
数字 {0:N0} 13  
货币 {0:c2} $12.36  
货币 {0:c4} $12.3656  
货币 "￥{0:N2}" ￥12.36  
科学计数法 {0:E3} 1.23E+001  
百分数 {0:P} 12.25% P and p present the same.
日期 {0:D} 2006年11月25日  
日期 {0:d} 2006-11-25  
日期 {0:f} 2006年11月25日 10:30  
日期 {0:F} 2006年11月25日 10:30:00  
日期 {0:s} 2006-11-26 10:30:00  
时间 {0:T} 10:30:00  
在设置GridView数据绑定控件的模版列时，总要设置显示的格式，这里是我查询一些资料后统计出来的。还有一个常规的选项是用数据库中默认的格式显示。]]> http://www.windsfly.cn/blog/default.asp?id=2016 <![CDATA[AspNetPager分页控件]]> sf223cn@yahoo.com.cn(admin) Sun,29 Aug 2010 01:53:47 +0800 http://www.windsfly.cn/blog/default.asp?id=2016 1.首先到www.webdiyer.com下载最新的AspNetPager.dll，直接在vs2005中添加引用即可。
2.在页面上注册控件，引入该控件，当然，需要在页面中使用一个数据载体，我这里使用的是repeater控件。
<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>

<!--省略-->

<Webdiyer:AspNetPager id="AspNetPager1" runat="server" HorizontalAlign="Right"  FirstPageText="<<" LastPageText=">>" PrevPageText="<" NextPageText=">" NumericButtonTextFormatString="-{0}-" Width="600px"

           ShowCustomInfoSection="Left" ShowBoxThreshold="2" PageSize="5"  InputBoxClass="text2" TextAfterInputBox="" OnPageChanging="AspNetPager1_PageChanging"  />3.cs代码
DataSet ds;
    SqlDataAdapter dr;
    SqlCommand com;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string strconn = System.Configuration.ConfigurationManager.ConnectionStrings["SperConnectionString1"].ToString();
            SqlConnection con = new SqlConnection(strconn);
            con.Open();
            com = new SqlCommand();
            com.Connection = con;
            com.CommandText = "select count(*) from Article";
            AspNetPager1.AlwaysShow = true;
            AspNetPager1.PageSize = 5;
            AspNetPager1.RecordCount = (int)com.ExecuteScalar();
            con.Close();
            RepeaterDataBind();
        }
    }
    private void RepeaterDataBind()
    {
        string strconn = System.Configuration.ConfigurationManager.ConnectionStrings["SperConnectionString1"].ToString();
        dr = new SqlDataAdapter("select * from Article", strconn);
        ds = new DataSet();
        dr.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "Article");
        this.Repeater2.DataSource = ds.Tables["Article"];
        this.Repeater2.DataBind();

    }

    protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
    {
        AspNetPager1.CurrentPageIndex = e.NewPageIndex;
        RepeaterDataBind();
    }
    protected string FormatString_Size_13(string str)
    {
        if (str.Length > 33)
        {
            str = str.Substring(0, 32) + "";
        }
        return str;
    }

4.最后修改AspNetPager控件的PageChanging事件为AspNetPager1_PageChanging就可以了。]]> http://www.windsfly.cn/blog/default.asp?id=2015 <![CDATA[AspNetPager用法]]> sf223cn@yahoo.com.cn(admin) Sun,29 Aug 2010 01:24:02 +0800 http://www.windsfly.cn/blog/default.asp?id=2015

<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>
<html>
<head runat="server">
    <title>AspNetPager用法最简单演示</title>
</head>
<body>
    <form id="form1" runat="server">
    <webdiyer:aspnetpager id="pager1" runat="server" ></webdiyer:aspnetpager>
    </form>   
</body>
</html>

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;

public partial class testpager : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        pager1.RecordCount = 235;
    }
}

不同于DataGrid控件，AspNetPager分页控件本身并不显示任何数据，而只显示页导航元素，数据在页面上的显示方式与该控件无关。该控件可以为DataGrid、DataList、Repeater以及自定义控件进行分页，配合Sql存储过程，分页性能较使用DataGrid分页有明显提升，尤其是当数据量大时性能可提升数倍！

    AspNetPager 2.0 中新增了通过Url来分页的功能，这使得访问者可以直接输入相应的Url来访问任何页面，并且搜索引擎也可以直接检索每个页面，若使用DataGrid的分页功能，这是无法实现的。

要使用 AspNetPager 分页控件，必须最少指定它的 RecordCount 属性，指定并编写 PageChanged 事件的处理程序。 RecordCount 属性指定要分页的所有数据的总项数，若未指定该值或该值小于等于 PageSize ，则AspNetPager控件不会显示任何内容。 若未指定并编写 PageChanged 事件处理程序，则当用户点击页导航元素或在页索引文本框中手式输入页索引并提交时AspNetPager不会跳转到指定的页。 AspNetPager控件的分页方法和DataGrid基本相同，即在它的 PageChanged 事件处理程序中将传递事件数据的 PageChangedEventArgs 的 NewPageIndex值赋给 AspNetPager的 CurrentPageIndex属性，然后重新将新的数据与数据显示控件绑定。

RecordCount :当页面第一次加载时，应以编程方式将从存储过程或Sql语句中返回的数据表中所有要分页的记录的总数赋予该属性，AspNetPager会将其保存的ViewState中并在页面回发时从ViewState中获取该值，因此避免了每次分页都要访问数据库而影响分页性能。AspNetPager根据要分页的所有数据的总项数和 PageSize 属性来计算显示所有数据需要的总页数，即 PageCount的值。

PageSize :该值获取或设置数据呈现控件每次要显示数据表中的的数据的项数，AspNetPager根据该值和 RecordCount 来计算显示所有数据需要的总页数，即 PageCount的值

        if (pager1.RecordCount <pager1.PageSize)
        {
            pager1.AlwaysShow = true;
        }

 

]]> http://www.windsfly.cn/blog/default.asp?id=2014 <![CDATA[AspNetPager分页实例]]> sf223cn@yahoo.com.cn(admin) Sun,29 Aug 2010 01:17:00 +0800 http://www.windsfly.cn/blog/default.asp?id=2014   <center>
  <form id="form1" runat="server">
  <div>
  <asp:GridView ID="GridView1" runat="server" PageSize="3" Width="379px" AutoGenerateColumns="False">
  <Columns>
  <asp:BoundField DataField="Company_ChineseName" />
  <asp:BoundField DataField="Company_X" />
  <asp:BoundField DataField="Company_Y" />
  <asp:BoundField DataField="Company_Phone" />
  <asp:BoundField DataField="Company_Address" />
  </Columns>
  </asp:GridView>
  </div>
  &nbsp; &nbsp;&nbsp;<br />
  <br />
  <webdiyer:AspNetPager ID="pageBind" runat="server" AlwaysShow="True" FirstPageText="&lt;font size=&quot;2&quot; color=&quot;blue&quot; size=&quot;Small&quot;&gt;&lt;b&gt;首页&lt;/b&gt;&lt;/font&gt;"
  HorizontalAlign="Center" LastPageText="&lt;font size=&quot;2&quot; color=&quot;green&quot; size=&quot;Small&quot;&gt;&lt;b&gt;末页&lt;/b&gt;&lt;/font&gt;"
  OnPageChanged="pageBind_PageChanged" PageSize="4" PrevPageText="&lt;font color=&quot;blue&quot; face=&quot;webdings&quot; &gt;3&lt;/font&gt;"
  ShowBoxThreshold="2" Width="300px" CustomInfoTextAlign="Justify"  
  MoreButtonType="Image" NavigationButtonType="Image" NumericButtonCount="3"  
  ShowCustomInfoSection="Left">
  </webdiyer:AspNetPager>
  </form>
  </center>
</body>
后台代码
using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using Wuqi.Webdiyer;

String MyConn;
  SqlConnection Conn;
  protected void Page_Load(object sender, EventArgs e)
  {

  MyConn = "server=.;database=XQ_Environment_mis;uid=sa;password=123456789";
  Conn = new SqlConnection(MyConn); //初始化连接
  if (!this.IsPostBack)
  {
  string sql;
  sql = "select count(*) from TB_Company";
  SqlCommand Cmd = new SqlCommand(sql, Conn);
  Conn.Open();
  this.pageBind.RecordCount = (int)Cmd.ExecuteScalar();
  Conn.Close();
  BindData();
  }
  }
  protected void BindData()
  {
  string sql;
  sql = "select * from TB_Company";

  SqlDataAdapter Ad = new SqlDataAdapter(sql, Conn);
  DataSet Ds = new DataSet();
  Ad.Fill(Ds, this.pageBind.PageSize * (this.pageBind.CurrentPageIndex - 1), this.pageBind.PageSize, "zjt");


  this.GridView1.DataSource = Ds.Tables["zjt"];
  this.GridView1.DataBind();
  AddCustomText();
  }
  public void AddCustomText()//这个事用来展示总共的数据条数，你当前所在的页面索引和总页数的
  {
  pageBind.CustomInfoText = "记录总数：<font color=\"blue\"><b>" + pageBind.RecordCount.ToString() + "</b></font>";
  pageBind.CustomInfoText += " 总页数：<font color=\"blue\"><b>" + pageBind.PageCount.ToString() + "</b></font>";
  pageBind.CustomInfoText += " 当前页：<font color=\"red\"><b>" + pageBind.CurrentPageIndex.ToString() + "</b></font>";

  }
  protected void pageBind_PageChanged(object src, PageChangedEventArgs e)
  {
  this.pageBind.CurrentPageIndex = e.NewPageIndex;
  BindData();
  }]]> http://www.windsfly.cn/blog/default.asp?id=2013 <![CDATA[AspNetPager样式以及使用（漂亮）]]> sf223cn@yahoo.com.cn(admin) Sun,29 Aug 2010 01:09:59 +0800 http://www.windsfly.cn/blog/default.asp?id=2013
　　自定义样式：

　　<style type="text/css">

　　/*拍拍网风格*/

　　.paginator { font: 11px Arial, Helvetica, sans-serif;padding:10px 20px 10px 0; margin: 0px;}

　　.paginator a {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;margin-right:2px}

　　.paginator a:visited {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;}

　　.paginator .cpb {padding: 1px 6px;font-weight: bold; font-size: 13px;border:none}

　　.paginator a:hover {color: #fff; background: #ffa501;border-color:#ffa501;text-decoration: none;}

　　/*淘宝风格*/

　　.paginator { font: 12px Arial, Helvetica, sans-serif;padding:10px 20px 10px 0; margin: 0px;}

　　.paginator a {border:solid 1px #ccc;color:#0063dc;cursor:pointer;text-decoration:none;}

　　.paginator a:visited {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;}

　　.paginator .cpb {border:1px solid #F50;font-weight:700;color:#F50;background-color:#ffeee5;}

　　.paginator a:hover {border:solid 1px #F50;color:#f60;text-decoration:none;}

　　.paginator a,.paginator a:visited,.paginator .cpb,.paginator a:hover

　　{float:left;height:16px;line-height:16px;min-width:10px;_width:10px;margin-right:5px;text-align:center;

　　white-space:nowrap;font-size:12px;font-family:Arial,SimSun;padding:0 3px;}

　　</style>

　　前台：<table cellpadding="0" cellspacing="0" align="center" width="99%" class="border">

　　<tr>

　　<td align="left" colspan="2">

　　<webdiyer:AspNetPager ID="AspNetPager1" CssClass="paginator"   CurrentPageButtonClass="cpb" runat="server" AlwaysShow="True"

　　FirstPageText="首页"  LastPageText="尾页" NextPageText="下一页"  PageSize="20" PrevPageText="上一页"  ShowCustomInfoSection="Left"

　　ShowInputBox="Never" onpagechanged="AspNetPager1_PageChanged"  CustomInfoTextAlign="Left" LayoutType="Table"  >

　　</webdiyer:AspNetPager>

　　</td>

　　</tr>

　　</table>

　　后台：

　　void bindData()

　　{       .......绑定语句       this.AspNetPager1.CustomInfoHTML = string.Format("当前第{0}/{1}页 共{2}条记录 每页{3}条", new object[] { this.AspNetPager1.CurrentPageIndex, this.AspNetPager1.PageCount, this.AspNetPager1.RecordCount, this.AspNetPager1.PageSize });

　　}

　　protected void AspNetPager1_PageChanged(object src, EventArgs e)

　　{

　　bindData();

　　}
]]> http://www.windsfly.cn/blog/default.asp?id=2012 <![CDATA[ASP.NET改变checkboxlist选中项字体颜色]]> sf223cn@yahoo.com.cn(admin) Thu,26 Aug 2010 20:36:44 +0800 http://www.windsfly.cn/blog/default.asp?id=2012
程序代码 程序代码
<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <asp:CheckBoxList ID="CheckBoxList1" runat="server" Width="728px" Height="40px" RepeatDirection="Horizontal">
                    <asp:ListItem Value="报纸">报纸</asp:ListItem>
                    <asp:ListItem>杂志</asp:ListItem>
                    <asp:ListItem>广播</asp:ListItem>
                    <asp:ListItem>电视</asp:ListItem>
                    <asp:ListItem>网络</asp:ListItem>
                    <asp:ListItem>亲朋介绍</asp:ListItem>
                    <asp:ListItem>招生简章</asp:ListItem>
                    <asp:ListItem>招生咨询会</asp:ListItem>
</asp:CheckBoxList>
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" Width="107px" />
    </form>
</body>
</html>


2.default.aspx.cs
程序代码 程序代码
protected void Page_Load(object sender, EventArgs e)
    {
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        for (int i = 0; i < this.CheckBoxList1.Items.Count; i++)
        {
            if (this.CheckBoxList1.Items[i].Selected == true)
            {
               this.CheckBoxList1.Items[i].Text = this.CheckBoxList1.Items[i].Text.IndexOf("font") == -1 ? "<font color=’red’>" + this.CheckBoxList1.Items[i].Text + "</font>" : this.CheckBoxList1.Items[i].Text.Replace("Black", "red");
            }
            else
            {
                this.CheckBoxList1.Items[i].Text =this.CheckBoxList1.Items[i].Text.IndexOf("font") == -1 ? "<font color=’Black’>" + this.CheckBoxList1.Items[i].Text + "</font>" : this.CheckBoxList1.Items[i].Text.Replace("red", "Black");

            }
        }
    }
]]> http://www.windsfly.cn/blog/default.asp?id=2011 <![CDATA[google的日程安排的.net实现]]> sf223cn@yahoo.com.cn(admin) Wed,25 Aug 2010 08:21:10 +0800 http://www.windsfly.cn/blog/default.asp?id=2011
程序代码 程序代码
protected void DayLogCalendar_DayRender(object sender, DayRenderEventArgs e)
{
if (e.Day.IsOtherMonth)
{
e.Cell.Controls.Clear();
}
else
{
dt = Pdl.GetTitle(ViewState[ "id "].ToString(), e.Day.Date.ToString( "yyyy-MM-dd "));
int j = dt.Rows.Count;
//string stem = " ";

if (j > 0)
{
e.Cell.Controls.Add(new LiteralControl( "&nbsp;&nbsp; <a title= &apos; " + dt.Rows[0][ "Content "].ToString() + " &apos; target= &apos;_self &apos; >内容查看 </a > "));
}

}

}
]]> http://www.windsfly.cn/blog/default.asp?id=1989 <![CDATA[asp.net c# CheckBoxList绑定数据,读取出来]]> sf223cn@yahoo.com.cn(admin) Wed,18 Aug 2010 17:37:08 +0800 http://www.windsfly.cn/blog/default.asp?id=1989
C#代码
程序代码 程序代码
protected void Page_Load(object sender, EventArgs e)  
{  
    if (!Page.IsPostBack)  
    {  
        SqlConnection con = GetDBCon.GetCon();  
        con.Open();  
        SqlDataAdapter sda = new SqlDataAdapter("select * from admin", con);  
        DataSet ds = new DataSet();  
        sda.Fill(ds,"admin");  
        this.CheckBoxList1.DataSource = ds.Tables[0];  
        this.CheckBoxList1.DataTextField = "username";//绑定的字段名  
        this.CheckBoxList1.DataValueField = "userid";//绑定的值  
        this.CheckBoxList1.DataBind();          
    }  
}


2.循环读取出来

C#代码
程序代码 程序代码
protected void CheckBoxList1_SelectedIndexChanged(object sender, EventArgs e)  
{  
    this.Lab2.Text = "";  
    for (int i = 0; i < CheckBoxList1.Items.Count; i++)  
    {  
        if (this.CheckBoxList1.Items[i].Selected)  
        {  
            this.Lab2.Text = this.Lab2.Text+CheckBoxList1.Items[i].Text+".";  
        }  
    }  
}
  ]]> http://www.windsfly.cn/blog/default.asp?id=1988 <![CDATA[asp.net CheckBoxList 取值与勾选，复选框后台控制前台checkbox选中]]> sf223cn@yahoo.com.cn(admin) Wed,18 Aug 2010 17:31:48 +0800 http://www.windsfly.cn/blog/default.asp?id=1988 Html代码
程序代码 程序代码
<asp:CheckBoxList ID = "cblJL" runat = "server" RepeatDirection="Horizontal" Width="100%">  
    <asp:ListItem>当前记录</asp:ListItem>  
    <asp:ListItem>当前页</asp:ListItem>  
    <asp:ListItem>全部记录</asp:ListItem>  
</asp:CheckBoxList>


后台3种方式：
第一种：获得CheckBox的值

C#代码
程序代码 程序代码
string save_cblJL = "";  
for (int i = 0; i < this.cblJL.Items.Count; i++)  
{  
    if (this.cblJL.Items[i].Selected == true)  
    {  
        save_cblJL += this.cblJL.Items[i].Value + ",";  
    }  
}  
Response.Write(save_cblJL);


第二种：获得CheckBox的值

C#代码
程序代码 程序代码
string str_Save_cblJL = "";  
foreach (ListItem li in cblJL.Items)  
{  
    if (li.Selected == true)  
    {  
        str_Save_cblJL += li.Value + ",";  
    }  
}  
Response.Write(str_Save_cblJL);
  

第三种：从后台给前台CheckBox赋值

C#代码
程序代码 程序代码
string strapp = "当前记录,当前页,全部记录,";  
string[] strtemp = strapp.Split(',');  
foreach (string str in strtemp)  
{  
    for (int i = 0; i < cblJL.Items.Count; i++)  
    {  
        if (this.cblJL.Items[i].Value == str)  
        {  
            this.cblJL.Items[i].Selected = true;  
        }  
    }  
}


http://heisetoufa.javaeye.com/blog/293193]]> http://www.windsfly.cn/blog/default.asp?id=1987 <![CDATA[ASP.NET改变checkboxlist选中项字体颜色]]> sf223cn@yahoo.com.cn(admin) Wed,18 Aug 2010 17:25:00 +0800 http://www.windsfly.cn/blog/default.asp?id=1987
程序代码 程序代码
<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <asp:CheckBoxList ID="CheckBoxList1" runat="server" Width="728px" Height="40px" RepeatDirection="Horizontal">
                    <asp:ListItem Value="报纸">报纸</asp:ListItem>
                    <asp:ListItem>杂志</asp:ListItem>
                    <asp:ListItem>广播</asp:ListItem>
                    <asp:ListItem>电视</asp:ListItem>
                    <asp:ListItem>网络</asp:ListItem>
                    <asp:ListItem>亲朋介绍</asp:ListItem>
                    <asp:ListItem>招生简章</asp:ListItem>
                    <asp:ListItem>招生咨询会</asp:ListItem>
</asp:CheckBoxList>
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" Width="107px" />
    </form>
</body>
</html>


2.default.aspx.cs
程序代码 程序代码
protected void Page_Load(object sender, EventArgs e)
    {
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        for (int i = 0; i < this.CheckBoxList1.Items.Count; i++)
        {
            if (this.CheckBoxList1.Items[i].Selected == true)
            {
               this.CheckBoxList1.Items[i].Text = this.CheckBoxList1.Items[i].Text.IndexOf("font") == -1 ? "<font color=’red’>" + this.CheckBoxList1.Items[i].Text + "</font>" : this.CheckBoxList1.Items[i].Text.Replace("Black", "red");
            }
            else
            {
                this.CheckBoxList1.Items[i].Text =this.CheckBoxList1.Items[i].Text.IndexOf("font") == -1 ? "<font color=’Black’>" + this.CheckBoxList1.Items[i].Text + "</font>" : this.CheckBoxList1.Items[i].Text.Replace("red", "Black");

            }
        }
    }

]]>