Text box, button and data retrieval

leeWozyWarren · November 23rd, 2011, 03:36 PM

Hi all,

I have a webform page in aspx and have a text box and a button on the page. I want a user to be able to enter a name and press the button, for the control to search a database and then return the results in a gridview or DetailsView.

However, I can't find anywhere that shows me the code... In the book it shows you how to get the control to post the text box content to a label, but nothing more!

Please help!

Regards

Lee

Imar · November 23rd, 2011, 04:15 PM

You can use LINQ to EF to query the database and then bind the results to a Grid. E.g. (untested, pseudo code only)

Code:

 
var someStuff = from s in SomeStuff where s.Name.StartsWith(textBox1.Text). select s;
myGrid.DataSource = someStuff;
myGrid.DataBind();

Hope this helps,

Imar

leeWozyWarren · November 23rd, 2011, 04:21 PM

And this code would go into the aspx page not the code behind?

My markup is below:

Code:

<%@ Page Title="" Language="VB" MasterPageFile="~/Site.master" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="ManagementTest_Default" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
<p>Search for a client by name:</p>
    <p>
         <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        <asp:Button ID="Button1" runat="server" Text="Button" />
    </p>

    <p>
        Or please select a condition from the dropdown list below:</p>

Imar · November 23rd, 2011, 04:32 PM

It would go in the Code Behind, in the Button's Click handler to be precise....

Imar

leeWozyWarren · November 23rd, 2011, 06:13 PM

Thanks Imar.

Could you expand on the code you gave me earlier?

Regards

Lee

Imar · November 23rd, 2011, 06:26 PM

What would you like me to expand on? It's similar to some other stuff in the book. Remember the Repeater in the Review pages? This is exactly the same concept.

Cheers,

Imar

leeWozyWarren · November 23rd, 2011, 06:37 PM

What part of the code are needing me to replace with my own elements and what need to stay as yo wrote them? I know that this needs testing as you said it was untested!

Like SomeStuff.... select s.... StartsWIth.....

Code:

var someStuff = from s in SomeStuff where s.Name.StartsWith(textBox1.Text). select s;
myGrid.DataSource = someStuff;
myGrid.DataBind();

I'll also re-read the stuff on repeaters...

Thanks.

Imar · November 24th, 2011, 04:11 AM

The first line is a custom query which you need to replace with your own. Again, take a look at the Code Behind of the varous Reviews pages to see examples.

Cheers,

Imar