CODEWITHSUNDEEP
c#asp.nettextbox
Marijn
Marijn

Reputation: 345

Fill a textbox with data from database

I have a couple of textboxes on my page and want to fill them with data from the database. I do the query and get (in my case) a Film object back wich i use to fill textboxes but it won't work. Here is my code:

private void FilmInfo(int gekozenFilm)
{
    BLFilm blFilm = new BLFilm();
    Film film = blFilm.GetFilmById(gekozenFilm);
    TextBoxFilm.Text = film.Naam;
    TextBoxRelease.Text = film.Releasedatum.ToString();
    TextBoxTrailer.Text = film.Filmpje;
    TextBoxAfbeelding.Text = film.Afbeelding;
}

There is a Film object in film but for some reason the textboxes don't display the text.

Code (that is relevant) for the entire page:

protected void ListBoxMovies_SelectedIndexChanged(object sender, EventArgs e)
{
    int gekozenFilm;
    gekozenFilm = Convert.ToInt32(ListBoxMovies.SelectedItem.Value);
    FilmInfo(gekozenFilm);
}
private void FilmInfo(int gekozenFilm)
    {
        BLFilm blFilm = new BLFilm();
        Film film = blFilm.GetFilmById(gekozenFilm);
        TextBoxFilm.Text = film.Naam;
        TextBoxRelease.Text = film.Releasedatum.ToString();
        TextBoxTrailer.Text = film.Filmpje;
        TextBoxAfbeelding.Text = film.Afbeelding;
    }

The .aspx page

<form id="form1" runat="server">
        <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
        <section id="context">
            <article id="left">

                <h2>Movie CRUD</h2>
                <div class="seperator">
                    <!-- seperator -->
                    <asp:Label ID="LabelNaam" runat="server" Text="Naam"></asp:Label>
                    <asp:TextBox ID="TextBoxFilm" runat="server" Width="250px"></asp:TextBox>
                    <br />
                    <asp:Label ID="LabelRelease" runat="server" Text="Releasedatum"></asp:Label>
                    <asp:TextBox ID="TextBoxRelease" runat="server" Width="185px"></asp:TextBox>
                    <br />
                    <asp:Label ID="LabelTrailer" runat="server" Text="Trailer"></asp:Label>
                    <asp:TextBox ID="TextBoxTrailer" runat="server" Width="241px"></asp:TextBox>
                    <br />
                    <asp:Label ID="Label1" runat="server" Text="Afbeelding"></asp:Label>
                    <asp:TextBox ID="TextBoxAfbeelding" runat="server" Width="209px"></asp:TextBox>
                </div>
</article>
            <article id="right">
                <h2>Movies</h2>
                <asp:ListBox ID="ListBoxMovies" runat="server" Height="141px" Width="315px" OnSelectedIndexChanged="ListBoxMovies_SelectedIndexChanged" ViewStateMode="Inherit" AutoPostBack="True"></asp:ListBox>
</article>
        </section>


    </form>

I've tried putting breakpoint pretty much everywhere and textboxes have a value for text but on the page it remains empty?

Upvotes: 3

Views: 2491

Answers (2)

Marnik Wouters
Marnik Wouters

Reputation: 220

It'll be a good idea to check if your updatetemplate contains the Textboxes you want to fill.

Upvotes: 2

Tommaso DS
Tommaso DS

Reputation: 211

Why don't you use a Recordset? It is very easy to use and I think is good for your situation: Here more info

Upvotes: 0

Related Questions