Beginner - How to populate asp literal from Access database
Posted on 2009-05-05
I'm trying to populate an asp literal control on my asp.net page with data from an Access database.
I've got this to connect to my database:
<asp:AccessDataSource id="AccessDataSource2" runat="server" DataFile="app_data/pedigrees.mdb" SelectCommand="SELECT [Horse] FROM [Pedigrees] WHERE ([ID] = ?)">
<asp:parameter DefaultValue="1" Name="ID" Type="Int32" />
I'd like to use an asp literal to get the value of "Horse" and display it on my page.
Any help will be greatly appreciated.
PS - I don't have a clue what I'm doing.