protected void ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if ((e.Item.ItemType.Equals(ListItemType.Item) || e.Item.ItemType.Equals(ListItemType.AlternatingItem)) && (e.Item.ItemIndex + 1) % ProductsPerPage == 0)
{
e.Item.Controls.Add(new LiteralControl("<tr><td class=\"PageBreak\" ></td></tr>"));
}
}
Posts Tagged ‘代码’
在Repeater中添加换页符
2009年09月04日 星期五
Styling Excel cells with mso-number-format
2009年02月11日 星期三
| mso-number-format:”0″ | NO Decimals |
| mso-number-format:”0\.000″ | 3 Decimals |
| mso-number-format:”\#\,\#\#0\.000″ | Comma with 3 dec |
| mso-number-format:”mm\/dd\/yy” | Date7 |
| mso-number-format:”mmmm\ d\,\ yyyy” | Date9 |
| mso-number-format:”m\/d\/yy\ h\:mm\ AM\/PM” | D -T AMPM |
| mso-number-format:”Short Date” | 01/03/1998 |
| mso-number-format:”Medium Date” | 01-mar-98 |
| mso-number-format:”d\-mmm\-yyyy” | 01-mar-1998 |
| mso-number-format:”Short Time” | 5:16 |
| mso-number-format:”Medium Time” | 5:16 am |
| mso-number-format:”Long Time” | 5:16:21:00 |
| mso-number-format:”Percent” | Percent – two decimals |
| mso-number-format:”0%” | Percent – no decimals |
| mso-number-format:”0\.E+00″ | Scientific Notation |
| mso-number-format:”\@” | Text |
| mso-number-format:”\#\ ???\/???” | Fractions – up to 3 digits (312/943) |
| mso-number-format:”\0022£\0022\#\,\#\#0\.00″ | £12.76 |
| mso-number-format:”\#\,\#\#0\.00_ \;\[Red\]\-\#\,\#\#0\.00\ “ | 2 decimals, negative numbers in red and signed (1.56 -1.56) |
用法举例：
当我们用<%@page contentType=”application/vnd.ms-excel; charset=UTF-8″%>的方法导出网页文件为excel时，如果导出的数据中有数字以0开头，则该0会被省略，为了保留这个处于首位的0，可以在表格的style中加入：
style=’mso-number-format:”\@”;’
这样的话，导出的该表格中首位为0的数字就会将该0保留啦！
SQL脚本 — 行变列
2008年12月01日 星期一
create table aaa
(
col nvarchar(10)
)
insert into aaa
select 1
union
select 2
union
select 3
declare @sql varchar(8000)
set @sql=’select ‘
select @sql=@sql+’max(case col when ”’+ col +”’ then col end) + ”,” + ‘
from (select distinct col from aaa) a
set @sql=left(@sql,len(@sql)-1)
set @sql=@sql+’ from aaa’
–print @sql
exec(@sql)
drop table aaa
Convert integer to Enum instance
2008年10月27日 星期一
public void EnumInstanceFromInt()
{
// The .NET Framework contains an Enum called DayOfWeek.
// Let’s generate some Enum instances from int values.
// Usually you wouldn’t cast an instance of an existing Enum to an int
// in order to create an Enum instance. :-) You would have the actual
// integer value, perhaps a value from a database where the int value of
// the enum was stored.
DayOfWeek wednesday =
(DayOfWeek)Enum.ToObject(typeof(DayOfWeek), (int)DayOfWeek.Wednesday);
DayOfWeek sunday =
(DayOfWeek)Enum.ToObject(typeof(DayOfWeek), (int)DayOfWeek.Sunday);
DayOfWeek tgif =
(DayOfWeek)Enum.ToObject(typeof(DayOfWeek), (int)DayOfWeek.Friday);
lblOutput.Text = wednesday.ToString()
+ “. Int value = ” + ((int)wednesday).ToString() + “\n”;
lblOutput.Text += sunday.ToString()
+ “. Int value = ” + ((int)sunday).ToString() + “\n”;
lblOutput.Text += tgif.ToString()
+ “. Int value = ” + ((int)tgif).ToString() + “\n”;
}
Result:
Wednesday. Int value = 3
Sunday. Int value = 0
Friday. Int value = 5
在网页上启动桌面应用程序
2008年10月08日 星期三
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Test]
@=”Test”
“URL Protocol”=”应用程序路径 %l”
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Test\DefaultIcon]
@=”%SystemRoot%\\system32\\url.dll,0″
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Test\Shell]
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Test\Shell\open]
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Test\Shell\open\command]
@=”应用程序路径 %l”
注意: %1是百分号加上数字1
在网页上加一个这样的链接：
<a href=’Test://para1¶2¶3′>启动桌面应用程序</a>
如果用户点击这个网页链接，在注册表中对应的应用程序就可以被启动了。
来源: http://www.cnblogs.com/ilovejolly/archive/2007/06/25/794566.html
将 yyyyMMdd 格式字符串转换成 yyyy-MM-dd 格式的日期
2008年09月25日 星期四
DateTime.ParseExact(输入的字符串,”yyyyMMdd”,System.Globalization.CultureInfo.CurrentCulture)