Click here to Skip to main content
15,905,136 members
Home / Discussions / Web Development
   

Web Development

 
AnswerRe: mysqli truncate Pin
Kornfeld Eliyahu Peter28-Sep-14 1:39
professionalKornfeld Eliyahu Peter28-Sep-14 1:39 
Questioncontinuously scroll multiple pictures on a web page using c# and html Pin
Mike Margolius24-Sep-14 8:20
professionalMike Margolius24-Sep-14 8:20 
AnswerRe: continuously scroll multiple pictures on a web page using c# and html Pin
Ali Al Omairi(Abu AlHassan)24-Sep-14 8:57
professionalAli Al Omairi(Abu AlHassan)24-Sep-14 8:57 
GeneralRe: continuously scroll multiple pictures on a web page using c# and html Pin
Mike Margolius24-Sep-14 9:33
professionalMike Margolius24-Sep-14 9:33 
GeneralRe: continuously scroll multiple pictures on a web page using c# and html Pin
Ali Al Omairi(Abu AlHassan)28-Sep-14 0:49
professionalAli Al Omairi(Abu AlHassan)28-Sep-14 0:49 
AnswerRe: continuously scroll multiple pictures on a web page using c# and html Pin
Richard Deeming24-Sep-14 12:19
mveRichard Deeming24-Sep-14 12:19 
Questionopacity inheritance Pin
Ali Al Omairi(Abu AlHassan)24-Sep-14 1:20
professionalAli Al Omairi(Abu AlHassan)24-Sep-14 1:20 
Questionreload data into gridview control based upon user selection criteria Pin
dcof21-Sep-14 14:42
dcof21-Sep-14 14:42 
XML
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>

QuestionHow to add/update/delete content txt file? Pin
Member 1039071520-Sep-14 4:38
Member 1039071520-Sep-14 4:38 
AnswerRe: How to add/update/delete content txt file? Pin
Richard MacCutchan20-Sep-14 21:09
mveRichard MacCutchan20-Sep-14 21:09 
SuggestionRe: How to add/update/delete content txt file? Pin
Kornfeld Eliyahu Peter20-Sep-14 22:14
professionalKornfeld Eliyahu Peter20-Sep-14 22:14 
Questionhow c++ client calls the js function which is in the firefox extension Pin
l3563319-Sep-14 0:51
l3563319-Sep-14 0:51 
QuestionAny latest UI framework Pin
npatel1234518-Sep-14 7:05
npatel1234518-Sep-14 7:05 
AnswerRe: Any latest UI framework Pin
pitechindore18-Dec-14 0:05
pitechindore18-Dec-14 0:05 
QuestionRequire Js Pin
Suraj Sahoo | Coding Passion16-Sep-14 19:34
professionalSuraj Sahoo | Coding Passion16-Sep-14 19:34 
AnswerRe: Require Js Pin
Bernhard Hiller16-Sep-14 21:45
Bernhard Hiller16-Sep-14 21:45 
GeneralRe: Require Js Pin
Suraj Sahoo | Coding Passion16-Sep-14 21:50
professionalSuraj Sahoo | Coding Passion16-Sep-14 21:50 
AnswerRe: Require Js Pin
thatraja18-Sep-14 3:29
professionalthatraja18-Sep-14 3:29 
GeneralRe: Require Js Pin
Suraj Sahoo | Coding Passion18-Sep-14 4:04
professionalSuraj Sahoo | Coding Passion18-Sep-14 4:04 
GeneralRe: Require Js Pin
thatraja18-Sep-14 4:14
professionalthatraja18-Sep-14 4:14 
GeneralRe: Require Js Pin
Suraj Sahoo | Coding Passion18-Sep-14 4:16
professionalSuraj Sahoo | Coding Passion18-Sep-14 4:16 
Generalpop up on button click in wordpress Pin
AMRITESH ASTHANA15-Sep-14 2:19
AMRITESH ASTHANA15-Sep-14 2:19 
QuestionVideo streaming in web Pin
Dharmaraj Balasubramanian15-Sep-14 2:03
Dharmaraj Balasubramanian15-Sep-14 2:03 
QuestionMessage Closed Pin
7-Sep-14 9:21
hadoopTraining7-Sep-14 9:21 
QuestionWeb API - Pros And Cons of more open structure. Pin
Rover2341 - Mark Dickinson7-Sep-14 7:46
Rover2341 - Mark Dickinson7-Sep-14 7:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.