前台
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
BorderStyle="None" BorderWidth="0px" DataKeyNames="ID" Font-Size="12px" ForeColor="Black"
Width="97%" OnPageIndexChanging="GridView1_PageIndexChanging">
<PagerStyle Font-Size="15px" HorizontalAlign="Center" />
<PagerSettings FirstPageText="第一页" LastPageText="最后一页" Mode="NumericFirstLast" NextPageText="下一页"
PreviousPageText="上一页" />
<Columns>
<asp:TemplateField HeaderText="Equick Number">
<ItemTemplate>
<asp:Label ID="Label4" runat="server" Height="26px" Text='<%# Bind("order_ID") %>'
Width="80px"></asp:Label>
</ItemTemplate>
<HeaderStyle BackColor="Gainsboro" ForeColor="Black" />
<ItemStyle Font-Names="Arial" />
</asp:TemplateField>
<asp:TemplateField HeaderText="地点/签收人" SortExpression="track_Place">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("track_signedby") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("track_signedby") %>'></asp:Label>
</ItemTemplate>
<HeaderStyle BackColor="Gainsboro" />
<ItemStyle Font-Names="Arial" />
</asp:TemplateField>
<asp:TemplateField HeaderText="货物状态" SortExpression="track_Status">
<EditItemTemplate>
<asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("ftrack_Status") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%# Bind("ftrack_Status") %>'></asp:Label>
</ItemTemplate>
<HeaderStyle BackColor="Gainsboro" />
<ItemStyle Font-Names="Arial" />
</asp:TemplateField>
<asp:TemplateField HeaderText="目的地国家">
<ItemTemplate>
<asp:Label ID="Labeln" runat="server" Height="26px" Text='<%# Bind("country") %>'
Width="80px"></asp:Label>
</ItemTemplate>
<HeaderStyle BackColor="Gainsboro" />
<ItemStyle Font-Names="Arial" />
</asp:TemplateField>
<asp:TemplateField HeaderText="发件日期">
<ItemTemplate>
<asp:Label ID="Labeln1" runat="server" Height="26px" Text='<%# Bind("track_time") %>'
Width="80px"></asp:Label>
</ItemTemplate>
<HeaderStyle BackColor="Gainsboro" />
<ItemStyle Font-Names="Arial" />
</asp:TemplateField>
<asp:TemplateField HeaderText="查看详情">
<ItemTemplate>
<asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/imgs/1_03.jpg" OnClick="ImageButton1_Click" /><br />
</ItemTemplate>
<HeaderStyle BackColor="Gainsboro" HorizontalAlign="Left" />
<ItemStyle HorizontalAlign="Left" Font-Names="Arial" />
</asp:TemplateField>
</Columns>
<PagerStyle Font-Overline="False" Font-Underline="False" ForeColor="#6F6F6F" CssClass="DGPage" />
<RowStyle Font-Names="Arial" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
后台 private void bind()
{
string ordersid = "";
string[] arry;
StringBuilder orders = new StringBuilder();
string fuhao = "','";
string end = "'";
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["WLConnectionString3"].ConnectionString);
DataSet ds = new DataSet();
Regex rg = new Regex(@",");
if (Session["ordersid"] != null)
{
ordersid = Session["ordersid"].ToString();
arry = rg.Split(ordersid);
Session["ordersid"] = null;
for (int i = 0; i < arry.Length; i++)
{
orders.Append(arry[i].Trim().ToString());
orders.Append(fuhao);
}
orders.Append(end);
string sql="";
Response.Write("arr"+arry.Length.ToString());
sql = string.Format("SELECT * FROM Order_Track WHERE order_ID IN('{0}) AND Track_time = any (SELECT MAX(track_time) FROM Order_Track WHERE order_id IN ('{1}) GROUP BY Order_ID)", orders, orders);
SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
strcon.Open();
SqlCommand com3 = new SqlCommand(sql, strcon);
int a = com3.ExecuteNonQuery();
if (a <1)
{
this.Label6.Text = "无查询结果";
} strcon.Close();
*/
//} }
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
this.GridView1.PageIndex = e.NewPageIndex;
this.bind();
} 比如说数据有两页 ,那么第一次加载时显示第一页的,可以翻到第2页 ,但是在第2页时 ,就不能再接着翻到第一页了 ,好像是只能从前往后翻 ,不能从后往前翻 ,怎么回事啊
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
BorderStyle="None" BorderWidth="0px" DataKeyNames="ID" Font-Size="12px" ForeColor="Black"
Width="97%" OnPageIndexChanging="GridView1_PageIndexChanging">
<PagerStyle Font-Size="15px" HorizontalAlign="Center" />
<PagerSettings FirstPageText="第一页" LastPageText="最后一页" Mode="NumericFirstLast" NextPageText="下一页"
PreviousPageText="上一页" />
<Columns>
<asp:TemplateField HeaderText="Equick Number">
<ItemTemplate>
<asp:Label ID="Label4" runat="server" Height="26px" Text='<%# Bind("order_ID") %>'
Width="80px"></asp:Label>
</ItemTemplate>
<HeaderStyle BackColor="Gainsboro" ForeColor="Black" />
<ItemStyle Font-Names="Arial" />
</asp:TemplateField>
<asp:TemplateField HeaderText="地点/签收人" SortExpression="track_Place">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("track_signedby") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("track_signedby") %>'></asp:Label>
</ItemTemplate>
<HeaderStyle BackColor="Gainsboro" />
<ItemStyle Font-Names="Arial" />
</asp:TemplateField>
<asp:TemplateField HeaderText="货物状态" SortExpression="track_Status">
<EditItemTemplate>
<asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("ftrack_Status") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%# Bind("ftrack_Status") %>'></asp:Label>
</ItemTemplate>
<HeaderStyle BackColor="Gainsboro" />
<ItemStyle Font-Names="Arial" />
</asp:TemplateField>
<asp:TemplateField HeaderText="目的地国家">
<ItemTemplate>
<asp:Label ID="Labeln" runat="server" Height="26px" Text='<%# Bind("country") %>'
Width="80px"></asp:Label>
</ItemTemplate>
<HeaderStyle BackColor="Gainsboro" />
<ItemStyle Font-Names="Arial" />
</asp:TemplateField>
<asp:TemplateField HeaderText="发件日期">
<ItemTemplate>
<asp:Label ID="Labeln1" runat="server" Height="26px" Text='<%# Bind("track_time") %>'
Width="80px"></asp:Label>
</ItemTemplate>
<HeaderStyle BackColor="Gainsboro" />
<ItemStyle Font-Names="Arial" />
</asp:TemplateField>
<asp:TemplateField HeaderText="查看详情">
<ItemTemplate>
<asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/imgs/1_03.jpg" OnClick="ImageButton1_Click" /><br />
</ItemTemplate>
<HeaderStyle BackColor="Gainsboro" HorizontalAlign="Left" />
<ItemStyle HorizontalAlign="Left" Font-Names="Arial" />
</asp:TemplateField>
</Columns>
<PagerStyle Font-Overline="False" Font-Underline="False" ForeColor="#6F6F6F" CssClass="DGPage" />
<RowStyle Font-Names="Arial" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
后台 private void bind()
{
string ordersid = "";
string[] arry;
StringBuilder orders = new StringBuilder();
string fuhao = "','";
string end = "'";
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["WLConnectionString3"].ConnectionString);
DataSet ds = new DataSet();
Regex rg = new Regex(@",");
if (Session["ordersid"] != null)
{
ordersid = Session["ordersid"].ToString();
arry = rg.Split(ordersid);
Session["ordersid"] = null;
for (int i = 0; i < arry.Length; i++)
{
orders.Append(arry[i].Trim().ToString());
orders.Append(fuhao);
}
orders.Append(end);
string sql="";
Response.Write("arr"+arry.Length.ToString());
sql = string.Format("SELECT * FROM Order_Track WHERE order_ID IN('{0}) AND Track_time = any (SELECT MAX(track_time) FROM Order_Track WHERE order_id IN ('{1}) GROUP BY Order_ID)", orders, orders);
SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
strcon.Open();
SqlCommand com3 = new SqlCommand(sql, strcon);
int a = com3.ExecuteNonQuery();
if (a <1)
{
this.Label6.Text = "无查询结果";
} strcon.Close();
*/
//} }
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
this.GridView1.PageIndex = e.NewPageIndex;
this.bind();
} 比如说数据有两页 ,那么第一次加载时显示第一页的,可以翻到第2页 ,但是在第2页时 ,就不能再接着翻到第一页了 ,好像是只能从前往后翻 ,不能从后往前翻 ,怎么回事啊
解决方案 »
- 求高手解答,怎样改才能运行正确
- 关于XAML的问题,大家进来给看看,顶者有分,谢谢
- 急。。高分。。如何在打开网页时弹出一个对话框,最好能防拦截的。。
- win2k配置成为.net服务器,浏览服务器上的站点时,没有反应。也不报错。
- 关于存储过程分页的问题?
- 请问一下,那里有"Visual Source Safe 6.0"下载,网上搜了半天,全是补丁,有的话,留个地址,本机有的话,我开空间,你来上传,急着用,在线等
- 请大家帮我看看这个错误:
- 学妹请问几个学习ASP。NET时的网站,UP有分!
- 如何用ASP.NET+SQL SERVER显示数据?
- 为什么自动给我去掉逗号和括号,不知是何原因。请大家和版主帮忙看看!!!
- IIS浏览不到FCKeditor编辑器
- xwc:xdatagrid的分页怎么用呀?
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
this.GridView1.PageIndex = e.NewPageIndex; this.GridView1.DataSource = dt; //重新绑定你的数据源 this.GridView1.bind();
}