Where's your page_load event handler code?
On 9/15/05, sas0riza <[EMAIL PROTECTED]> wrote:
>
> Here's my code:
>
> Function GetCardholderByLastandFirst(ByVal lastName As String, ByVal
> firstName As String) As System.Data.DataSet
> Dim connectionString As String = _
> Dim dbConnection As System.Data.IDbConnection = New
> System.Data.SqlClient.SqlConnection(connectionString)
>
> Dim queryString As String = "SELECT [CardVerification].
> [CardVerificationUID], [CardVerification].[LastName], ["& _
> "CardVerification].[FirstName], [CardVerification].
> [MiddleInitial], [CardVerifica"& _
> "tion].[Email] FROM [CardVerification] WHERE [CardVerification].
> [LastName] LIKE ('%' + @LastName + '%') AND [CardVerification].
> [FirstName] LIKE ('%' + @FirstName + '%')"
> Dim dbCommand As System.Data.IDbCommand = New
> System.Data.SqlClient.SqlCommand
> dbCommand.CommandText = queryString
> dbCommand.Connection = dbConnection
>
> Dim dbParam_lastName As System.Data.IDataParameter = New
> System.Data.SqlClient.SqlParameter
> dbParam_lastName.ParameterName = "@LastName"
> dbParam_lastName.Value = lastName
> dbParam_lastName.DbType = System.Data.DbType.String
> dbCommand.Parameters.Add(dbParam_lastName)
> Dim dbParam_firstName As System.Data.IDataParameter =
> New System.Data.SqlClient.SqlParameter
> dbParam_firstName.ParameterName = "@FirstName"
> dbParam_firstName.Value = firstName
> dbParam_firstName.DbType = System.Data.DbType.String
> dbCommand.Parameters.Add(dbParam_firstName)
>
> Dim dataAdapter As System.Data.IDbDataAdapter = New
> System.Data.SqlClient.SqlDataAdapter
> dataAdapter.SelectCommand = dbCommand
> Dim dataSet As System.Data.DataSet = New
> System.Data.DataSet
> dataAdapter.Fill(dataSet)
>
> Return dataSet
> End Function
>
>
>
>
> Function GetCardholderByLast(ByVal lastName As String) As
> System.Data.DataSet
> Dim connectionString As String = _
> Dim dbConnection As System.Data.IDbConnection = New
> System.Data.SqlClient.SqlConnection(connectionString)
>
> Dim queryString As String = "SELECT [CardVerification].
> [CardVerificationUID], [CardVerification].[LastName], ["& _
> "CardVerification].[FirstName], [CardVerification].
> [MiddleInitial], [CardVerifica"& _
> "tion].[Email] FROM [CardVerification] WHERE [CardVerification].
> [LastName] LIKE ('%' + @LastName + '%')"
> Dim dbCommand As System.Data.IDbCommand = New
> System.Data.SqlClient.SqlCommand
> dbCommand.CommandText = queryString
> dbCommand.Connection = dbConnection
>
> Dim dbParam_lastName As System.Data.IDataParameter = New
> System.Data.SqlClient.SqlParameter
> dbParam_lastName.ParameterName = "@LastName"
> dbParam_lastName.Value = lastName
> dbParam_lastName.DbType = System.Data.DbType.String
> dbCommand.Parameters.Add(dbParam_lastName)
>
> Dim dataAdapter As System.Data.IDbDataAdapter = New
> System.Data.SqlClient.SqlDataAdapter
> dataAdapter.SelectCommand = dbCommand
> Dim dataSet As System.Data.DataSet = New
> System.Data.DataSet
> dataAdapter.Fill(dataSet)
>
> Return dataSet
> End Function
>
>
>
>
> Function GetCardholderByFirst(ByVal firstName As String) As
> System.Data.DataSet
> Dim connectionString As String = _
> Dim dbConnection As System.Data.IDbConnection = New
> System.Data.SqlClient.SqlConnection(connectionString)
>
> Dim queryString As String = "SELECT [CardVerification].
> [CardVerificationUID], [CardVerification].[LastName], ["& _
> "CardVerification].[FirstName], [CardVerification].
> [MiddleInitial], [CardVerifica"& _
> "tion].[Email] FROM [CardVerification] WHERE ([CardVerification].
> [FirstName] = @F"& _
> "irstName)"
> Dim dbCommand As System.Data.IDbCommand = New
> System.Data.SqlClient.SqlCommand
> dbCommand.CommandText = queryString
> dbCommand.Connection = dbConnection
>
> Dim dbParam_firstName As System.Data.IDataParameter =
> New System.Data.SqlClient.SqlParameter
> dbParam_firstName.ParameterName = "@FirstName"
> dbParam_firstName.Value = firstName
> dbParam_firstName.DbType = System.Data.DbType.String
> dbCommand.Parameters.Add(dbParam_firstName)
>
> Dim dataAdapter As System.Data.IDbDataAdapter = New
> System.Data.SqlClient.SqlDataAdapter
> dataAdapter.SelectCommand = dbCommand
> Dim dataSet As System.Data.DataSet = New
> System.Data.DataSet
> dataAdapter.Fill(dataSet)
>
> Return dataSet
> End Function
>
>
>
>
>
>
>
> Sub search_Click(sender As Object, e As EventArgs)
>
>
> dgCardholderInfo.DataSource = GetCardholderByLastandFirst
> (lname.text, fname.text)
> dgCardholderInfo.DataBind()
> Label1.Text = "Click on the person's last name that you want to
> edit:"
> Label1.Visible = True
>
>
> End Sub
>
>
>
> Sub search2_Click(sender As Object, e As EventArgs)
>
> If lname2.text = ""
> dgCardholderInfo.DataSource = GetCardholderByFirst(fname2.text)
> dgCardholderInfo.DataBind()
>
> else if fname2.text = ""
> dgCardholderInfo.DataSource = GetCardholderByLast(lname2.text)
> dgCardholderInfo.DataBind()
>
>
> End If
>
> End Sub
>
>
>
>
>
> Sub dgCardholderInfo_Page(sender as Object, e as
> DataGridPageChangedEventArgs)
> 'Assign the CurrentPageIdex property to the new page index value
>
> dgCardholderInfo.CurrentPageIndex = e.NewPageIndex
>
> 'Rebind the data to the Datagrid
> dgCardholderInfo.DataSource = GetCardholderByLastandFirst
> (lname.text, fname.text)
> dgCardholderInfo.DataBind()
>
> End Sub
>
>
>
>
> <p align="right">
> <a href="Cardholders.aspx">Restart</a>
> </p>
> <p>
> Last Name:
> <asp:TextBox id="lname" runat="server"
> cssclass="NormalTextBox"></asp:TextBox>
> <b>-AND-</b> First Name:
> <asp:TextBox id="fname" runat="server"
> cssclass="NormalTextBox"></asp:TextBox>
> <asp:Button id="search"
> onclick="search_Click" runat="server" cssclass="CommandButton"
> Text="Search"></asp:Button>
> <input class="CommandButton"
> type="reset" value="Clear" />
> </p>
> <p>
> Last Name:
> <asp:TextBox id="lname2" runat="server"
> cssclass="NormalTextBox" EnableViewState="False"></asp:TextBox>
> <b>-OR-</b> First Name:
> <asp:TextBox id="fname2" runat="server"
> cssclass="NormalTextBox"></asp:TextBox>
> <asp:Button id="search2"
> onclick="search2_Click" runat="server" cssclass="CommandButton"
> Text="Search"></asp:Button>
> <input class="CommandButton"
> type="reset" value="Clear" />
> </p>
> <p>
> <asp:Label id="Label1" runat="server"
> cssclass="Normal" visible="False"></asp:Label>
> <br />
> <asp:DataGrid id="dgCardholderInfo"
> runat="server" cssclass="Normal" AutoGenerateColumns="False"
> AllowPaging="True" OnPageIndexChanged="dgCardholderInfo_Page">
> <HeaderStyle font-
> bold="True"></HeaderStyle>
> <PagerStyle
> mode="NumericPages"></PagerStyle>
> <Columns>
> <asp:HyperLinkColumn
> DataNavigateUrlField="CardVerificationUID"
> DataNavigateUrlFormatString="Cardholders2.aspx?CardVerificationUID=
> {0}" DataTextField="LastName" SortExpression="LastName"
> HeaderText="LastName"></asp:HyperLinkColumn>
> <asp:BoundColumn
> DataField="FirstName" HeaderText="FirstName"></asp:BoundColumn>
> <asp:BoundColumn
> DataField="MiddleInitial" HeaderText="MI"></asp:BoundColumn>
> <asp:BoundColumn
> DataField="Email" HeaderText="Email"></asp:BoundColumn>
> </Columns>
> </asp:DataGrid>
> </p>
>
>
> Thanks...
>
>
> --- In [email protected], Dean Fiala
> <[EMAIL PROTECTED]> wrote:
> > Let's see the code.
> >
> > On 9/15/05, sas0riza <[EMAIL PROTECTED]> wrote:
> > >
> > > Hello,
> > >
> > > I have a couple of search fields, where you can search by both
> first
> > > and last name, or last or first name. I have 2 buttons, search
> and
> > > clear. When you hit search, the record(s) is returned in a
> datagrid.
> > >
> > > However, I am having a problem when you refresh the page, even
> > > entering in something different in the search field, once I hit
> > > search, the same results get returned in the datagrid and what I
> > > entered in the search before reappears in search textbox. How do
> I
> > > prevent this?
> > >
> > > In addition, my datagrid is paging enabled and when I go to the
> next
> > > page, I get different records than what I want to show. e.g. I
> > > search by last name 'lee' so the datagrid returns all the records
> > > with 'lee' but when I go to the next page, the records are mixed
> up.
> > > I'm not sure why?
> > >
> > > Any help is greatly appreciated.
> > >
> > > Thanks.
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> > --
> > Dean Fiala
> > Very Practical Software, Inc
> > http://www.vpsw.com
> >
> >
> > [Non-text portions of this message have been removed]
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
--
Dean Fiala
Very Practical Software, Inc
http://www.vpsw.com
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
