Hello, I am creating a website in which users can update index information. I am a newb.
The data is stored on 2 tables in sql2000.
One table has the index key, name, display name.
The 2nd table has Index Key,Index return key, Return, Return date.
In vs2008 I want to have to pages with the first grid view with 3 colums: Index name, Date as of, and options(hyper link to second page)
2nd page would have gridview with just that specified index: date list, returns, options(edit/delete link)
I am a little stuck on these:
I believe since i have data of both tables on the first gridset I need to merge the tables in a data set. With a sql command to give the most recent date to populate on the grid?
Second question what commands do I use for the second page to update the returns onto the sql database?
Thanks for you help !!!!