Binding accessdatasource to "normal" controls

16 Feb 2007 12:01 PM

musosdev

Hi

I'm trying to use my AccessDataSource which retrieves 1 record based on a
querystring, and display the various fields as Label controls on my page.

At the moment, the code compiles, but nothing appears on the page. Can some
explain why, and what I need to do to make it work?

Cheers, Dan.

Here's my data source...

<asp:AccessDataSource ID="adsStory" runat="server"
DataFile="~/App_Data/BeggarsBelief.mdb"
        SelectCommand="SELECT [StoryTitle], [Synopsis], [Story], [Name],
[Visits] FROM [Stories] WHERE ([StoryID] = ?)">
        <SelectParameters>
            <asp:QueryStringParameter Type="Int32"
                QueryStringField="id" />
        </SelectParameters>
</asp:AccessDataSource>

and here's the label for the StoryTitle...

<h1><asp:Label runat="server" Text='<%# DataBinder.Eval(adsStory,
"[StoryTitle]") %>' ID="lblHeading" /></h1>

There's nothing added to the codebehind for the page.

19 Feb 2007 5:38 AM

WenYuan Wang

Hi Dan,

According to your description, I understand that Label("lblHeading") cannot
display the StoryTitle from the AccessDataSouce("adsStory"). Please feel
free to correct me if I have misunderstood anything here.

AccessDataSource only work with data-bound controls (GridView,Repeater...).
For these reason, we can not bind AccessDataSource and Label directly.
There are two ways to achieve this.
1. Using a FormView control binding with AccessDataSource.
<asp:FormView ID="FormView1" runat="server" DataSourceID="adsStory">
        <ItemTemplate>
        <h1><asp:Label runat="server" Text='<%# Eval("StoryTitle") %>'
ID="lblHeading" /></h1>
        </ItemTemplate>
</asp:FormView>

2. Using Codebehind to get value from AccessDataSource and set it to Label.
this. lblHeading.Text =
((DataView)(adsStory.Select(DataSourceSelectArguments.Empty)))[0]["
StoryTitle"].ToString();

Please feel free to reply me if you have anything unclear. I'm glad to work
with you.
Hope this helps.
Sincerely.
Wen Yuan

22 Feb 2007 12:10 PM

WenYuan Wang

Hi Dan,

I haven't heard from you two days. I just want to know if the issue has
been resolved.
Please feel free to let me know if you have anything unclear.

Have a great day.
Best regards,
Wen Yuan