Gridview and Relational data

[Saber]

I've two tables in SQL Server 2000:

tblAds: ADid (PK), ADname, ADcatID
tblCategories: CatID (PK), CatName

and some data for example:

tblAds
^^^^^^
1,intel,3
2,amd,3
3,sony,5
4,toshiba,5
tblCategories
^^^^^^^^^^
1,food
2,travel
3,computer
4,application
5,tv

I've a GridView and I want when binding tblAds in GridView,
the user see:
1,intel,computer instead of 1,intel,3
of course there is a relationship from tblAds(ADcatID) to
tblCategories(CatID) but I don't know
how to show that in GridView and also be able to delete and update.
I have to do some hard coding or there is a solution in VS 2005 wizards?

Thanks
Saber S.

[Oren]

hi Saber,

Create a stored procedure with the logic that you need and retrieves it to
your page.

Oren.

"Saber" wrote:

I've two tables in SQL Server 2000:

tblAds: ADid (PK), ADname, ADcatID
tblCategories: CatID (PK), CatName

and some data for example:

tblAds
^^^^^^
1,intel,3
2,amd,3
3,sony,5
4,toshiba,5
tblCategories
^^^^^^^^^^
1,food
2,travel
3,computer
4,application
5,tv

I've a GridView and I want when binding tblAds in GridView,
the user see:
1,intel,computer instead of 1,intel,3
of course there is a relationship from tblAds(ADcatID) to
tblCategories(CatID) but I don't know
how to show that in GridView and also be able to delete and update.
I have to do some hard coding or there is a solution in VS 2005 wizards?

Thanks
Saber S.

[Saber]

Thanks Oren,
OK. I'll do that,
I thought there is an easier way, VS 2005 made us lazy ;)
"Oren" <Or**@discussions.microsoft.com> wrote in message
news:32**********************************@microsof t.com...

hi Saber,

Create a stored procedure with the logic that you need and retrieves it to
your page.

Oren.

"Saber" wrote:

I've two tables in SQL Server 2000:

tblAds: ADid (PK), ADname, ADcatID
tblCategories: CatID (PK), CatName

and some data for example:

tblAds
^^^^^^
1,intel,3
2,amd,3
3,sony,5
4,toshiba,5
tblCategories
^^^^^^^^^^
1,food
2,travel
3,computer
4,application
5,tv

I've a GridView and I want when binding tblAds in GridView,
the user see:
1,intel,computer instead of 1,intel,3
of course there is a relationship from tblAds(ADcatID) to
tblCategories(CatID) but I don't know
how to show that in GridView and also be able to delete and update.
I have to do some hard coding or there is a solution in VS 2005 wizards?

Thanks
Saber S.