Restricting cols with a data view

microsoft.public.dotnet.framework.adonet

12 Apr 2006 3:11 AM

Ant

Hi,

I've always used Database views to restrict columns from the user. Is this
what ADO Dataviews are also meant for? I see how you can filter rows with a
data view, but how about columns? Can this be done with a dataview? Is there
a better mechanism to do this with?

Thanks for any ideas in advance.
Ant

12 Apr 2006 5:23 AM

Cor Ligthert [MVP]

Ant,

You can do that in version 2005 with the overloaded function
dataview.totable. In earlier versions you have to do that in a loop.

I hope this helps,

Cor

Show quote

"Ant" <A**@discussions.microsoft.com> schreef in bericht
news:F8A15D8C-63C9-4847-B663-C0EEDE0C0D9D@microsoft.com...
> Hi,
>
> I've always used Database views to restrict columns from the user. Is this
> what ADO Dataviews are also meant for? I see how you can filter rows with
> a
> data view, but how about columns? Can this be done with a dataview? Is
> there
> a better mechanism to do this with?
>
> Thanks for any ideas in advance.
> Ant