asp.net

blinkivxx · Apr 28, 2012

I should want to show the whole database and allow page when the page loaded. I add the founction of "find" to the same page. when the "find" was acted, Data was Bound and Showed, but the "Page_load" will to be executed. so , the Data After "find" and the whole Data are showed on the same page. how to do it ????? whether I shall take advantage to custom "<form>" ? how to do it in ASP.NET??? Thank you very much! Sincerely ! Haley program: <%@ Register Tagprefix="UserControl" TagName="head" src=http://aspmessageboard.com/archive/index.php/"head.ascx"%> <%@ Register Tagprefix="UserControl" TagName="footer" src="footer.ascx"%> <%@ Import Namespace = "System.Data" %> <%@ Import Namespace = "System.Data.SQLClient" %> <script language="VB" runat="server"> Sub Page_Load(sender As Object, e As EventArgs) ' Only bind the data on the first visit to the page If Not Page.IsPostBack BindSQL() End If End Sub 'Create an variable in Global scope Dim ResultCount as Integer Sub BindSQL() Dim MyConnection As SqlConnection Dim DS as Dataset Dim MyCommand As SqlDataAdapter Dim strConn As String = "user id=sa;password=;database=**;server=**;" Dim RcdCount As Integer 'Open up our connection with our connection object MyConnection = New SQLConnection(strConn) 'To execute our Sql Statement and provide out active connection MyCommand = New SqlDataAdapter("SearchGlossary", MyConnection) MyCommand.SelectCommand.CommandType=CommandType.St oredprocedure 'Create instance of dataset object and fill our predetermined datagrid with it and we name it DS = new Dataset() MyCommand.Fill(DS, "pubs") RcdCount = DS.Tables("pubs").Rows.Count.ToString() Pubs.Pagesize = CInt(ps.SelectedItem.Value) If Not Page.IsPostback Pubs.CurrentPageIndex = 0 End if ResultCount = RcdCount RecordCount.Text = "" & RcdCount & " record found" 'Now we assign the dataview to the datasource of the datagrid and we send it right on it Try Pubs.DataSource = DS Pubs.Databind() Catch e As Exception Pubs.CurrentPageIndex = 0 End Try If Pubs.CurrentPageIndex <> 0 Then Call Prev_Buttons() Firstbutton.Visible = true Prevbutton.Visible = true else Firstbutton.Visible = false Prevbutton.Visible = false end if If Pubs.CurrentPageIndex <> (Pubs.PageCount-1) then Call Next_Buttons() NextButton.Visible = true Lastbutton.Visible = true else NextButton.Visible = false Lastbutton.Visible = False end if lblPageCount.Text = "Page " & Pubs.CurrentPageIndex + 1 & " of " & Pubs.PageCount End Sub Sub PagerButtonClick(sender As Object, e As EventArgs) 'used by external paging UI Dim arg As String = sender.CommandArgument Select arg Case "next": If (Pubs.CurrentPageIndex < (Pubs.PageCount - 1)) Then Pubs.CurrentPageIndex += 1 End If Case "prev": If (Pubs.CurrentPageIndex > 0) Then Pubs.CurrentPageIndex -= 1 End If Case "last": Pubs.CurrentPageIndex = (Pubs.PageCount - 1) Case Else: Pubs.CurrentPageIndex = Convert.ToInt32(arg) End Select BindSQL() End Sub Sub Prev_Buttons() Dim PrevSet As String If Pubs.CurrentPageIndex+1 <> 1 and ResultCount <> -1 Then PrevSet = Pubs.PageSize PrevButton.Text = ("< Prev " & PrevSet) If Pubs.CurrentPageIndex+1 = Pubs.PageCount Then FirstButton.Text = ("<< 1st Page") End If End If End Sub Sub Next_Buttons() Dim NextSet As String If Pubs.CurrentPageIndex+1 < Pubs.PageCount Then NextSet = Pubs.PageSize NextButton.Text = ("Next" & NextSet & " >") End If If Pubs.CurrentPageIndex+1 = Pubs.PageCount-1 Then Dim EndCount As Integer = ResultCount - (Pubs.PageSize * (Pubs.CurrentPageIndex+1)) NextButton.Text = ("Next" & EndCount & " >") End If End Sub Sub Repage(sender As Object, e As EventArgs) Pubs.CurrentPageIndex = 0 BindSQL() End Sub Sub onClick_button(obj as Object,e as EventArgs) Dim Glossary as String =box1.text Dim StrConn as String ="user id=sa;password=;DataBase=**;Server=**;" Dim objDataSet as New DataSet() Dim objConn As New SqlConnection(StrConn) Dim StrSql as String ="select * from Glossary where chinese like '%" & Glossary & "%' or English like '%" & Glossary & "%';" Dim objAdapter as New sqlDataAdapter(StrSql,objConn) objAdapter.fill(objDataSet,"Glossary") Dim Rcd as string Rcd=objDataSet.Tables("Glossary").Rows.Count.ToString Dim objDataView As New DataView(objDataSet.Tables("Glossary")) DataGrid1.DataSource()=objDataView DataGrid1.DataBind() label1.text=Rcd &"record found" If DataGrid1.Items.Count=0 Then Label1.Text="sorry,Not found" End If End Sub </script> <LINK href="images/index.css" rel=stylesheet> <BODY leftMargin=0 background=images/mybk2.gif topMargin=1> <Center> <UserControl:Head id="myhead" runat="server"/> <asp:Label id="lblPageCount" runat="server" /> <asp:label id="RecordCount" runat="server" /> <div align="center"> <table width="77%"> <tr align="center"> <td height="21"> <form runat="server"> Find Glossary: <asp:label id="label1" runat="server"/> <asp:textbox id="box1" runat="server"/> <asp:button id="button1" text="Find" onClick="onClick_button" runat="server"/> <asp

ataGrid id="DataGrid1" runat="server"/> <ASP

atagrid id="Pubs" runat="server" AllowPaging="True" AllowCustomPaging="False" AutoGenerateColumns="False" HeaderStyle-HorizontalAlign="Center" PagerStyle-Visible = "False" HeaderStyle-BackColor="#00CC00" HeaderStyle-ForeColor="White" > <Columns> <asp:BoundColumn HeaderText="ID" DataField="ID" ItemStyle-HorizontalAlign="Center" /> <asp:BoundColumn HeaderText="Chinese" DataField="Chinese" ItemStyle-HorizontalAlign="Center" /> <asp:BoundColumn HeaderText="English" DataField="English" DataFormatString="{0:d}" ItemStyle-HorizontalAlign="Right" /> </Columns> </asp

ataGrid> <asp:linkbutton id="Firstbutton" Text="<<1st Page" CommandArgument="0" runat="server" onClick="PagerButtonClick"/> <asp:linkbutton id="Prevbutton" Text= "" CommandArgument="prev" runat="server" onClick="PagerButtonClick"/>    <asp:linkbutton id="Nextbutton" Text= "" CommandArgument="next" runat="server" onClick="PagerButtonClick"/> <asp:linkbutton id="Lastbutton" Text="Last Page>>" CommandArgument="last" runat="server" onClick="PagerButtonClick"/> Change Pagesize <asp

ropDownList id="ps" runat="server"> <asp:ListItem>4</asp:ListItem> <asp:ListItem>5</asp:ListItem> <asp:ListItem>7</asp:ListItem> <asp:ListItem selected>10</asp:ListItem> <asp:ListItem>12</asp:ListItem> <asp:ListItem>15</asp:ListItem> <asp:ListItem>22</asp:ListItem> </asp

ropDownList> <asp:button text="Change Pagesize" runat="server" OnClick="RePage"/> </form> </Center> </td> </tr> </table> </div> <UserControl:footer id="myfooter" runat="server"/> </body> </html

asp.net

blinkivxx

New Member