Web Development

<pre lang="SQL">

In a vb.net 2010 web form application, the folllowing gridview control is loaded with data and 3

textboxes are displayed when the aspx page first loads. Now I want to allow the user to be able

to enter last name, first name, and/or middle name so they can search for 'selected' people by

name. This way less rows would be displayed in the gridview control

I would like to do one of the following options:
1. Have the user enter the appropriate name in up to 3 texboxes and click on a submit button. The

data would be reloaded into the gridview control displaying only the records the user selected to

view.
2. The other option would be if the user enters values in the applicable textboxes and the

gridview control would display the selected rows in the gridview control when the focus is lost

from each textbox.

Thus would you show me the code on how to accomplish this goal? The following is the applicable
aspx page:
<pre>
<asp:Content ID="Content1" ContentPlaceHolderID="MPHead" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MPContent" Runat="Server">

    <asp:TextBox ID="lname" runat="server"></asp:TextBox>
     <asp:TextBox ID="fname" runat="server"></asp:TextBox>
    <asp:TextBox ID="mname" runat="server"></asp:TextBox>
    <asp:GridView ID="GridViewSupport" runat="server" AutoGenerateColumns="False"
        DataSourceID="sqlCampusOPS" Width="987px">
        <Columns>
            <asp:BoundField DataField="lastName" HeaderText="Last Name"
                SortExpression="lastName" />
            <asp:BoundField DataField="firstName" HeaderText="First Name"
                SortExpression="firstName" />
            <asp:BoundField DataField="middleName" HeaderText="Middle Name"
                SortExpression="middleName" />
            <asp:BoundField DataField="suffix" HeaderText="Suffix"
                SortExpression="suffix" />
            <asp:BoundField DataField="userid" HeaderText="User Id"
                SortExpression="userid" />
            <asp:BoundField DataField="schoolnum" HeaderText="School Number"
                SortExpression="schoolnum" />
            <asp:BoundField DataField="spa" HeaderText="SPA" SortExpression="spa" />
            <asp:BoundField DataField="mrref" HeaderText="M Ref" SortExpression="mrref" />
        </Columns>
    </asp:GridView>


    <asp:SqlDataSource ID="sqlCampusOPS" runat="server"
    ConnectionString="<%$ ConnectionStrings:sqlCampusOPS %>" SelectCommand="SELECT i.[lastName]
            ,i.[firstName]
            ,i.[middleName]
            ,i.[suffix]
            ,a.[userid]
            ,a.schoolnum
            ,a.spa
            ,a.mrref
            from [OPS].[dbo].[Identity] i
            inner join  [OPS].[dbo].[Person] p on i.identityID = p.currentIdentityID
            inner join [OPS].[dbo].[UserAccount] u on u.personID = p.personID
            inner join [CampusOps].[dbo].[AtnLtrUsers] a on a.userid =u.username
              where (i.[lastName] like  '%' + @lname  + '%' or
               i.[firstName] like'%' + @fname + '%'
                   or i.[middleName]  like'%' + @mname + '%')
    or (@fname is null and @lname is null and @mname is null)
          order by  i.[lastName], i.[firstName], i.[middleName]"

CancelSelectOnNullParameter="False">
    <SelectParameters>
        <asp:ControlParameter ControlID="lname" Name="lname" PropertyName="Text" />
        <asp:ControlParameter ControlID="fname" Name="fname" PropertyName="Text" />
        <asp:ControlParameter ControlID="mname" Name="mname" PropertyName="Text" />
    </SelectParameters>
</asp:SqlDataSource>
</asp:Content>