«

Dear gurus,

I have a stored procedure which returns a set of rows.

How do I suppress a number of columns (not display) from dataset?
Is is DataSet is the right tool in this case?

Thank you.

Hai

Hello Jared,

Thank you very much but it did not seem to work or because I did not get
the syntax correct.

Hai

"Jared" <> wrote in message
news:...
> Hai,
> Before you bind the dataset, you can mark the columns as hidden. I
> haven't tried this code, but, it works on the WinForms datagrid. If you
> aren't going to use the hidden results of the stored procedure you should
> probably create a procedure that only returns the columns you need, it's
> probably a better option.
> HTH,
> Jared
>
> Dim ds As DataSet
> For Each col As DataColumn In ds.Tables(0).Columns
> Select Case col.ColumnName
> Case Is = "Hideme", "HideMeToo", "DontDisplay"
> col.ColumnMapping = MappingType.Hidden
> End Select
> Next
>
> "Hai" <> wrote in message
> news:%...
> > Dear gurus,
> >
> > I have a stored procedure which returns a set of rows.
> >
> > How do I suppress a number of columns (not display) from dataset?
> > Is is DataSet is the right tool in this case?
> >
> > Thank you.
> >
> > Hai
> >
> >
>
>

Jared,
Fantastic.
Thanks a lot

Hai

"Jared" <> wrote in message
news:...
> Hai,
> Like I said before, I haven't tried the code on a webforms datagrid
> before. I did find an article that states you cannot hide autogenerated
> columns in a web forms datagrid. There is an example that will produce the
> results you want.
> http://authors.aspalliance.com/aldot...mnarticle.aspx
> Jared
>
> "Hai" <> wrote in message
> news:...
> > Hello Jared,
> >
> > Thank you very much but it did not seem to work or because I did not
get
> > the syntax correct.
> >
> > Hai
> >
> > "Jared" <> wrote in message
> > news:...
> >> Hai,
> >> Before you bind the dataset, you can mark the columns as hidden. I
> >> haven't tried this code, but, it works on the WinForms datagrid. If you
> >> aren't going to use the hidden results of the stored procedure you
should
> >> probably create a procedure that only returns the columns you need,
it's
> >> probably a better option.
> >> HTH,
> >> Jared
> >>
> >> Dim ds As DataSet
> >> For Each col As DataColumn In ds.Tables(0).Columns
> >> Select Case col.ColumnName
> >> Case Is = "Hideme", "HideMeToo", "DontDisplay"
> >> col.ColumnMapping = MappingType.Hidden
> >> End Select
> >> Next
> >>
> >> "Hai" <> wrote in message
> >> news:%...
> >> > Dear gurus,
> >> >
> >> > I have a stored procedure which returns a set of rows.
> >> >
> >> > How do I suppress a number of columns (not display) from dataset?
> >> > Is is DataSet is the right tool in this case?
> >> >
> >> > Thank you.
> >> >
> >> > Hai
> >> >
> >> >
> >>
> >>
> >
> >
>
>