用Session是可以的,这是一个例子,用的是sql server的自带的数据库<%@ Page Language="VB" AutoEventWireup="True" %>
<%@Import namespace="System.Data"%>
<%@Import namespace="System.Data.SqlClient"%>
<%@Import namespace="System.Data.OleDb"%><html>
<script language="vb" runat=server>
Dim s as string
Dim sql as string
Dim ename As String
Dim eerq1 As String
Dim eerq2 As String
dim ecount as String
Dim edate1 As DateTime
Dim edate2 As DateTime
dim edate3 As DateTime
Sub xx(sender As Object, e As EventArgs)
If x.text = "" Then
Session("name") = ""
Else
Session("name") = x.text
End If
Response.Redirect("B.aspx")End SubSub Page_Load(sender As Object, e As EventArgs)
If Session("name") = Nothing Then
ename=""
sql = "select * from authors"
Else
ename = Session("name")sql = "select * from authors where au_lname like '%" + ename + "%'"
End IfIf Not IsPostBack Then
BindGrid()
End If
End SubSub MyDataGrid_Page(sender as Object, e As DataGridPageChangedEventArgs)
MyDataGrid.CurrentPageIndex = e.NewPageIndex
BindGrid()
End SubSub BindGrid() Dim sqlconnection1 as new sqlConnection("server=.;uid=sa;pwd=;database=pubs")sqlconnection1.OpenDim sqld as New SqlDataAdapter(sql ,sqlconnection1)Dim ds as New DataSet
sqld.Fill(ds,"authors")
MyDataGrid.DataSource=ds.Tables("authors").DefaultView
MyDataGrid.DataBind
ecount=(ds.Tables("authors").Rows.Count).ToStringResponse.Write("用户数目为"+ ecount + "清单如下:")sqlconnection1.CloseEnd Sub
</script>
<form runat="server">
<asp:DataGrid id="MyDataGrid"
AllowPaging="True"
PageSize="4"
OnPageIndexChanged="MyDataGrid_Page"
runat="server"
AutoGenerateColumns="False"
Width="600" align="center">
<HeaderStyle BackColor="Navy"
ForeColor="White"
Font-Bold="True" />
<PagerStyle Mode="NumericPages"
HorizontalAlign="Right" />
<columns>
<asp:boundcolumn datafield="au_lname" headertext="手机号" />
<asp:TemplateColumn HeaderText="答案">
<ItemTemplate>
<asp:Label ID="lblTotalPrice" Text='<%#(Container.DataItem("au_lname"))%>' Runat=server />
</ItemTemplate>
</asp:TemplateColumn>
<asp:boundcolumn datafield="au_lname" headertext="栏目类型"/>
<asp:boundcolumn datafield="au_lname" headertext="答题时间"/>
<asp:boundcolumn datafield="au_lname" headertext="是否正确"/></columns>
</asp:DataGrid>
<asp:textbox id=x runat=server />
<asp:button id=y runat=server text="搜索" OnClick="xx"/></form>
<%@Import namespace="System.Data"%>
<%@Import namespace="System.Data.SqlClient"%>
<%@Import namespace="System.Data.OleDb"%><html>
<script language="vb" runat=server>
Dim s as string
Dim sql as string
Dim ename As String
Dim eerq1 As String
Dim eerq2 As String
dim ecount as String
Dim edate1 As DateTime
Dim edate2 As DateTime
dim edate3 As DateTime
Sub xx(sender As Object, e As EventArgs)
If x.text = "" Then
Session("name") = ""
Else
Session("name") = x.text
End If
Response.Redirect("B.aspx")End SubSub Page_Load(sender As Object, e As EventArgs)
If Session("name") = Nothing Then
ename=""
sql = "select * from authors"
Else
ename = Session("name")sql = "select * from authors where au_lname like '%" + ename + "%'"
End IfIf Not IsPostBack Then
BindGrid()
End If
End SubSub MyDataGrid_Page(sender as Object, e As DataGridPageChangedEventArgs)
MyDataGrid.CurrentPageIndex = e.NewPageIndex
BindGrid()
End SubSub BindGrid() Dim sqlconnection1 as new sqlConnection("server=.;uid=sa;pwd=;database=pubs")sqlconnection1.OpenDim sqld as New SqlDataAdapter(sql ,sqlconnection1)Dim ds as New DataSet
sqld.Fill(ds,"authors")
MyDataGrid.DataSource=ds.Tables("authors").DefaultView
MyDataGrid.DataBind
ecount=(ds.Tables("authors").Rows.Count).ToStringResponse.Write("用户数目为"+ ecount + "清单如下:")sqlconnection1.CloseEnd Sub
</script>
<form runat="server">
<asp:DataGrid id="MyDataGrid"
AllowPaging="True"
PageSize="4"
OnPageIndexChanged="MyDataGrid_Page"
runat="server"
AutoGenerateColumns="False"
Width="600" align="center">
<HeaderStyle BackColor="Navy"
ForeColor="White"
Font-Bold="True" />
<PagerStyle Mode="NumericPages"
HorizontalAlign="Right" />
<columns>
<asp:boundcolumn datafield="au_lname" headertext="手机号" />
<asp:TemplateColumn HeaderText="答案">
<ItemTemplate>
<asp:Label ID="lblTotalPrice" Text='<%#(Container.DataItem("au_lname"))%>' Runat=server />
</ItemTemplate>
</asp:TemplateColumn>
<asp:boundcolumn datafield="au_lname" headertext="栏目类型"/>
<asp:boundcolumn datafield="au_lname" headertext="答题时间"/>
<asp:boundcolumn datafield="au_lname" headertext="是否正确"/></columns>
</asp:DataGrid>
<asp:textbox id=x runat=server />
<asp:button id=y runat=server text="搜索" OnClick="xx"/></form>
解决方案 »
- 如何在删除数据前给出是否删除的提示
- 想用 asp.net MVC 做个购物网站
- 急!高手指导,链接access数据库,数据填充问题。在线等
- Calendar控件获取日期并查询
- 急 关于iframe 传值问题 顶者有分
- System.Web.HttpContext.Current.Server.MapPath提示类或空间不存在!急!
- asp.net开发遇到的问题,请各位高手帮帮忙...
- DataGrid 的模板列问题(精通的进来,我不相信csdn没有高手)
- 一个IIS服务器能发布2个.net程序吗??急急。谢谢大家
- 不用组件如何分页啊不会是和3。0一样吧
- 在RegularExpressionValidator里求一正则表达式
- 如何限制TextBox只能输入二位数字,请给我一个例子?
DataGrid1.CurrentPageIndex = 0;
将它放置在条件查询的按钮里面