«

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.

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.
>
>
>

Thanks Oren,
OK. I'll do that,
I thought there is an easier way, VS 2005 made us lazy


"Oren" <> wrote in message
news:32A2FE9F-2758-43F3-8342-...
> 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.
>>
>>
>>