Ad:

ASP.NET Discussion Thread
Unsolved
Views: 15485

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Dec 22nd, 2004

Help with Databinding

Expand Post »

I am trying to databind one entry retrieved from a SQL statement.

All I want to do is databind in the code behind page.

For some reason I have lost my brain and cannot figure out how to do it....

Similar Threads

Populating & Retrieving Data in a listbox : ASP.NET (w/ VB.NET) in ASP.NET
Databinding in JSP in JSP
Databinding not updating object properties in C#
[Databinding] in VB.NET
DataBinding in C#

Horizon

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Dec 2004

Permalink

Dec 22nd, 2004

Re: Help with Databinding

Databind WHAT to WHAT? You have your data in SQL, you get it out and it's now inside, what? A DataReader? DataTable?

You want to bind this data to which ASP.NET Server control?

tgreer

Team Colleague

Reputation Points: 227

Solved Threads: 37

Made Her Cry

Offline

1,697 posts
since Dec 2004

Permalink

Dec 22nd, 2004

Re: Help with Databinding

Sorry I should have made myself clearer.

I was trying to databind to a label, and just found an easier way. Through the use of the Command Object.

I was losing my train of thought and went on to post the question but didnt realize I left out the main reason.

Horizon

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Dec 2004

Permalink

Dec 22nd, 2004

Re: Help with Databinding

Which Command object? For SQL Commands?

tgreer

Team Colleague

Reputation Points: 227

Solved Threads: 37

Made Her Cry

Offline

1,697 posts
since Dec 2004

Permalink

Dec 22nd, 2004

Re: Help with Databinding

Yes, sorry to say but you are not being very clear in what you are wanting to do.

Have you successfully connected to the SQL Server DB?

You can use a Container to the specific Value you want to associate with the LABEL Object.

Below is a sample to this code:

(Toggle Plain Text)

<asp:Label id="label1" runat="server"
  Text='<%# Container.DataItem("CustomerName") %>

Hope this helps!

Paladine

Team Colleague

Reputation Points: 211

Solved Threads: 27

Master Poster

Offline

793 posts
since Feb 2003

Permalink

Jun 27th, 2005

Re: Help with Databinding

So, would you use it like this:

ASP.NET Syntax (Toggle Plain Text)
<tr><td colspan="2"><hr color="#F53167" width="100%" size="3"></td></tr>
<tr><td colspan="2">
    <form id="form1" runat="server">
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:tcmConnectionString1 %>" SelectCommand="SELECT * FROM [prod]">
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:tcmConnectionString1 %>" SelectCommand="SELECT [prod_description] FROM [prod] WHERE ([ID] = @ID)">
            <SelectParameters>
                <asp:ControlParameter ControlID="DropDownList1" Name="ID" PropertyName="SelectedValue"
                    Type="Int64" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1"
            DataTextField="prod_name" DataValueField="ID">
        </asp:DropDownList><br />
        &nbsp;<asp:Label ID="Label1" runat="server" Text='<%# SQLDataSource2.DataItem("prod_description") %>'></asp:Label>
    </form></td></tr>
    </table>
<tr><td colspan="2"><hr color="#F53167" width="100%" size="3"></td></tr>
<tr><td colspan="2">
    <form id="form1" runat="server">
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:tcmConnectionString1 %>" SelectCommand="SELECT * FROM [prod]">
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:tcmConnectionString1 %>" SelectCommand="SELECT [prod_description] FROM [prod] WHERE ([ID] = @ID)">
            <SelectParameters>
                <asp:ControlParameter ControlID="DropDownList1" Name="ID" PropertyName="SelectedValue"
                    Type="Int64" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1"
            DataTextField="prod_name" DataValueField="ID">
        </asp:DropDownList><br />
        &nbsp;<asp:Label ID="Label1" runat="server" Text='<%# SQLDataSource2.DataItem("prod_description") %>'></asp:Label>
    </form></td></tr>
    </table>

I am pretty sure I am way off.

jturlington

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Jun 2005

Permalink

Jun 27th, 2005

Re: Help with Databinding

Please wrap your code in code tags. Please start a new thread, rather than posting your question as a reply to a resolved thread.

With ASP.NET, it's best practice to separate your pages into an "HTML" template, and a code-behind file.

tgreer

Team Colleague

Reputation Points: 227

Solved Threads: 37

Made Her Cry

Offline

1,697 posts
since Dec 2004

Permalink

Jun 27th, 2005

Re: Help with Databinding

editted post

jturlington

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Jun 2005

Permalink

Jun 27th, 2005

Re: Help with Databinding

Edited...ok. But what are you asking still?

Quote originally posted by jturlington ...

editted post

Paladine

Team Colleague

Reputation Points: 211

Solved Threads: 27

Master Poster

Offline

793 posts
since Feb 2003

Permalink

Jun 27th, 2005

Re: Help with Databinding

to have the dropdownlist change what the text of the label is.

jturlington

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Jun 2005

Page 1
2
Next

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: Use of Image control on Web Page

Next Thread in ASP.NET Forum Timeline: Type ' ' Not Defined

DaniWeb Message

Cancel Changes

User Name
Password