<%@ Page language="c#" Codebehind="WebForm1.aspx.cs" AutoEventWireup="false" Inherits="Maintain.WebForm1" %>
<%@ Register TagPrefix="webdiyer" Namespace="Wuqi.Webdiyer" Assembly="AspNetPager" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<TITLE>WebForm1</TITLE>
<META name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<META name="CODE_LANGUAGE" content="C#">
<META name="vs_defaultClientScript" content="JavaScript">
<META name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<BODY ms_positioning="GridLayout">
<FORM id="Form1" method="post" runat="server">
<ASP:REPEATER id="Repeater1" runat="server">
<ITEMTEMPLATE>
<%#DataBinder.Eval(Container.DataItem, "Title")%><br/>
</ITEMTEMPLATE>
</ASP:REPEATER>
<WEBDIYER:ASPNETPAGER id="AspNetPager1" style="Z-INDEX: 101; LEFT: 80px; POSITION: absolute; TOP: 136px"
runat="server"></WEBDIYER:ASPNETPAGER>
</FORM>
</BODY>
</HTML>
<%@ Register TagPrefix="webdiyer" Namespace="Wuqi.Webdiyer" Assembly="AspNetPager" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<TITLE>WebForm1</TITLE>
<META name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<META name="CODE_LANGUAGE" content="C#">
<META name="vs_defaultClientScript" content="JavaScript">
<META name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<BODY ms_positioning="GridLayout">
<FORM id="Form1" method="post" runat="server">
<ASP:REPEATER id="Repeater1" runat="server">
<ITEMTEMPLATE>
<%#DataBinder.Eval(Container.DataItem, "Title")%><br/>
</ITEMTEMPLATE>
</ASP:REPEATER>
<WEBDIYER:ASPNETPAGER id="AspNetPager1" style="Z-INDEX: 101; LEFT: 80px; POSITION: absolute; TOP: 136px"
runat="server"></WEBDIYER:ASPNETPAGER>
</FORM>
</BODY>
</HTML>
解决方案 »
- 浏览器阻止弹出窗口
- .net发邮件,以前可以,现在突然不行了
- [新手求助]数据库更新语句问题
- 求一段后台sql insert语句并把数据存到数据库中
- flash与asp.net交互的问题?
- 各位同胞问大家一个很简单但是很纠结的问题!纠结了两天了····
- vs2003配置问题 极其简单
- 请大家探讨一下.net的效率
- 如何来根据URL的值来启用datagrid的排序功能。
- 一点小问题:急死了!String strEscapedDeviceID = re.Replace("\", "\\");这句该怎么写才对?
- 请问qq的分组是怎么保存的?是保存在数据库的吗?它的表结构怎么设计?每个人的组名是不一致的,表的字段设计???
- JS中的变量如何在aspx.cs中引用?
using System.Collections;
using System.Data;
using System.Drawing;
using System.Web;
using System.Data.SqlClient;namespace Maintain
{
/// <summary>
/// WebForm1 的摘要说明。
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected Wuqi.Webdiyer.AspNetPager AspNetPager1;
protected System.Web.UI.WebControls.Repeater Repeater1;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
string connStr = "server=(local);database=northwind;uid=sa;pwd=xiaole"; SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand("answer", conn);
cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@pagesize", SqlDbType.Int, 4).Value = AspNetPager1.PageSize;
cmd.Parameters.Add("@pageindex", SqlDbType.Int, 4).Value = AspNetPager1.CurrentPageIndex;
cmd.Parameters.Add("@docount", SqlDbType.Bit);
cmd.Parameters["@docount"].Value = true;
conn.Open();
AspNetPager1.RecordCount = Convert.ToInt32(cmd.ExecuteScalar().ToString());
conn.Close(); cmd.Parameters["@docount"].Value = false;
conn.Open();
Repeater1.DataSource = cmd.ExecuteReader();
Repeater1.DataBind();
conn.Close();
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load); }
#endregion
}
}
(@pagesize int,
@pageindex int,
@docount bit)
as
set nocount on
if(@docount=1)
select count(EmployeeID) from Employees
else
begin
declare @PageLowerBound int
declare @PageUpperBound int
set @PageLowerBound=(@pageindex-1)*@pagesize
set @PageUpperBound=@PageLowerBound+@pagesize
create table #pageindex(id int identity(1,1) not null,nid int)
set rowcount @PageUpperBound
insert into #pageindex(nid)
select EmployeeID from Employees order by EmployeeID desc
select O.*
from Employees O,#pageindex p
where O.EmployeeID=p.nid and p.id>@PageLowerBound and p.id<=@PageUpperBound order by p.id
end
set nocount off