我正常执行sql语句提取数据,为什么有的ie可以正常显示所有数据列表,有的ie里有部分数据就不显示,有部分就显示呢?我的sql是:select t1.id as id,'['+t2.nodename+']'+t1.title as title,t2.ParentID as ParentID,t1.AddDate as AddDate from fbldbg t1,Node t2 where t1.nodeid=t2.nodeid and t2.Templateid =2265 and t1.SystemID=8747 and t1.nodeid>0 and t1.NodeID<>9749 and t1.adddate>='" + begin1 + "' and t1.adddate<'" + end1 + "' and t1.title = '"+ name +"' ORDER BY t1.AddDate奇怪了。
解决方案 »
- 关于数据绑定
- 在页面做视频播放
- 通过ColumnsName获取DataRow的数据
- 求帮组完成一个方法
- 请教VS2010的问题:
- 在EXCel中录制的宏 转到.net中用 System.Text.StringBuilder sb=new System .Text .StringBui
- 【请教】.aspx继承哪个类?
- 怎么在asp.net中使用存储过程啊..最好有输出和输入参数的过程
- 请教:通过查询到的title 和content内容分别赋值给两个Label如何提出这两个数据?请高手指教???
- web.config中字符&产生错误,应该用什么格式呢?
- SQL语句查询数据库的问题,“查询值的数目与目标字段中的数目不同。”
- 求教:ASP.Net MVC 路径问题
-----------------------------Test...........
.STYLE14 {font-size: 12px; font-weight: bold; color: #07519a; }
.STYLE15 {font-size: 12px; color: #07519a; }
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}.zi{
color:#000000;
text-decoration:none;
font-size:12px;
}
a.zi:hover{
color:#000000;}
</style>页面代码:<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ContentList.aspx.cs" Inherits="ContentList" %><!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>
<style type="text/css">
.STYLE14 {font-size: 12px; font-weight: bold; color: #07519a; }
.STYLE15 {font-size: 12px; color: #07519a; }
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}.zi{
color:#000000;
text-decoration:none;
font-size:12px;
}
a.zi:hover{
color:#000000;}
</style>
<script type="text/JavaScript">
<!--
function GP_popupConfirmMsg(msg) { //v1.0
document.MM_returnValue = confirm(msg);
}
//-->
</script>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /></head>
<body>
<form id="form1" runat="server">
<div>
<table width="960" align="center" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="44%">
</td>
</tr>
<tr>
<td colspan="2">
<table width="960" border="0" align="center" cellspacing="1" cellpadding="0">
<tr>
<td width="60%" height="22" align="center" ><span class="STYLE14">实绩报告</span></td>
<td width="40%" align="center" ><span class="STYLE14">提交日期</span></td>
</tr>
<asp:Repeater ID="RepArticleList" runat="server" onitemcommand="RepArticleList_ItemCommand">
<ItemTemplate>
<tr>
<td valign="middle" align="left" width="60%" height="22" background="Images/newsbg.gif">
<a target="_blank" href ="Content.aspx?ID=<%# DataBinder.Eval(Container.DataItem,"ID") %>" class="zi">
<span class="STYLE15"><%# DataBinder.Eval(Container.DataItem, "title")%></span>
</a>
</td>
<td width="40%" align="center" background="Images/newsbg.gif"><span class="STYLE15"><%# DataBinder.Eval(Container.DataItem, "adddate")%></span></td>
</tr>
</ItemTemplate>
</asp:Repeater>
<tr>
<td height="22" colspan="2" align="center" style="font-size: 12px; color: #003366">
当前页码:[<asp:Label ID="labPage" runat="server" Text="1" Font-Size="12px"></asp:Label>
] 总页数:<asp:Label ID="labBackPage" runat="server" Font-Size="12px"></asp:Label>
<asp:LinkButton ID="lnkbtnOne" runat="server" Font-Size="12px" OnClick="lnkbtnOne_Click">首页</asp:LinkButton>
<asp:LinkButton ID="lnkbtnUp" runat="server" Font-Size="12px" OnClick="lnkbtnUp_Click" >上一页</asp:LinkButton>
<asp:LinkButton ID="lnkbtnNext" runat="server" Font-Size="12px" OnClick="lnkbtnNext_Click">下一页</asp:LinkButton>
<asp:LinkButton ID="lnkbtnBack" runat="server" Font-Size="12px" OnClick="lnkbtnBack_Click">尾页</asp:LinkButton></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="12" style="width: 73px">
</td>
<td>
</td>
<td style="width: 555px">
</td>
<td></td>
</tr>
</table>
</div>
</form>
</body>
</html>
提取数据的代码:string name = Request.QueryString["name"].ToString().Trim();
DateTime begin1 = Convert.ToDateTime("2011-06-01");
DateTime end1 = Convert.ToDateTime("2011-08-01");
int curpage = Convert.ToInt32(labPage.Text); PagedDataSource ps = new PagedDataSource();
string strsql = "select t1.id as id,'['+t2.nodename+']'+t1.title as title,t2.ParentID as ParentID,t1.AddDate as AddDate from fbldbg t1,Node t2 where t1.nodeid=t2.nodeid and t2.Templateid =2265 and t1.SystemID=8747 and t1.nodeid>0 and t1.NodeID<>9749 and t1.adddate>='" + begin1 + "' and t1.adddate<'" + end1 + "' and t1.title like '%"+ name +"%' ORDER BY t1.AddDate";
dr = new SqlDataAdapter(strsql, sqlcon);
ds = new DataSet();
dr.Fill(ds, "tb_Vote"); ps.DataSource = ds.Tables[0].DefaultView;
ps.AllowPaging = true;
ps.PageSize = 20;
ps.CurrentPageIndex = curpage - 1;
this.lnkbtnUp.Enabled = true;
this.lnkbtnOne.Enabled = true;
this.lnkbtnNext.Enabled = true;
this.lnkbtnBack.Enabled = true; if (curpage == 1)
{
this.lnkbtnUp.Enabled = false;
this.lnkbtnOne.Enabled = false;
}
if (curpage == ps.PageCount)
{
this.lnkbtnNext.Enabled = false;
this.lnkbtnBack.Enabled = false;
}
this.labBackPage.Text = Convert.ToString(ps.PageCount);
this.RepArticleList.DataSource = ps;
this.RepArticleList.DataBind();
sqlcon.Close();
</a>像这句怎么加上Server.UrlEncode?
新手,谢谢了