retrieving data from sql database

[codekat]

Hi there!

(Using asp .net 2.0)

I have an application in which the latest URL needs to be retrieved from an SQL 2005 database.

I have the database set up, i need to assign myItem to be a value(URL) which is in the database.


I would like to know :

- How does the .aspx page retrive the data(url) under one column in a table my sql2005 database
- how can i retrieve the latest entry of a URL.. so that if myColumn starts with http: retrieve and check if its the latest out of all entries..

Any ideas how to tackle this? any info i should read up on?

Thanks in advance

[Shuja Ali]

Firs of all you need to know how ADO.NET works (I hope you already know that). Now second part of your question is you want to know the latest URL in the database. Do you have any column in your table that will tell you when the URL was entered or updated? If you so you can use that Column to get the latest URL.