Ask a Question related to ASP.NET Data Grid Control, Design and Development.
-
Hai #1
Manipulating Dataset
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
Hai Guest
-
Dataset.length(), dataset.hasnext() not working.. Why?
I have a dataset that has 3 items, yet when I test for it, it is "undefined". Any ideas why this property would not be available? Thanks Geoff -
Manipulating a 3d object
Hi, I am very new to Director, but I have made a 3d model in 3ds max, and have been able to import it as a new cast member. I want the user to... -
dataset.Databind error when dataset XML contains attributes...
I've come accross an interesting problem populating an asp.net datagrid. I am trying to bind XML data to a datagrid as I've done in countless other... -
Help with manipulating a string.
I've got a multiline text box that will feed the ^M at the end of each line. I want to capture it into a single line (which is done), but how do I... -
Ccopying a datatable content from an untyped dataset into a table which is inside a typed dataset
Hi All, I am facing problem in copying content of table from a untyped dataset into to a table inside the typed dataset. I wanted to copy the data... -
Jared #2 Re: Manipulating Dataset
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" <hai21century@yahoo.com> wrote in message
news:%23tvNidYrEHA.1964@TK2MSFTNGP12.phx.gbl...> 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 Guest
-
Hai #3 Re: Manipulating Dataset
Hello Jared,
Thank you very much but it did not seem to work or because I did not get
the syntax correct.
Hai
"Jared" <ask_me_for_it@nospam.com> wrote in message
news:10mfpub84vce38a@corp.supernews.com...> 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" <hai21century@yahoo.com> wrote in message
> news:%23tvNidYrEHA.1964@TK2MSFTNGP12.phx.gbl...>> > 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
> >
> >
>
Hai Guest
-
Jared #4 Re: Manipulating Dataset
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.
[url]http://authors.aspalliance.com/aldotnet/examples/hidecolumnarticle.aspx[/url]
Jared
"Hai" <hai21century@yahoo.com> wrote in message
news:OmlhUA8rEHA.1388@TK2MSFTNGP09.phx.gbl...> Hello Jared,
>
> Thank you very much but it did not seem to work or because I did not get
> the syntax correct.
>
> Hai
>
> "Jared" <ask_me_for_it@nospam.com> wrote in message
> news:10mfpub84vce38a@corp.supernews.com...>>> 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" <hai21century@yahoo.com> wrote in message
>> news:%23tvNidYrEHA.1964@TK2MSFTNGP12.phx.gbl...>>>> > 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 Guest
-
Hai #5 Re: Manipulating Dataset
Jared,
Fantastic.
Thanks a lot
Hai
"Jared" <ask_me_for_it@nospam.com> wrote in message
news:10mnfeffarv0u31@corp.supernews.com...get> 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.
> [url]http://authors.aspalliance.com/aldotnet/examples/hidecolumnarticle.aspx[/url]
> Jared
>
> "Hai" <hai21century@yahoo.com> wrote in message
> news:OmlhUA8rEHA.1388@TK2MSFTNGP09.phx.gbl...> > Hello Jared,
> >
> > Thank you very much but it did not seem to work or because I did notshould> > the syntax correct.
> >
> > Hai
> >
> > "Jared" <ask_me_for_it@nospam.com> wrote in message
> > news:10mfpub84vce38a@corp.supernews.com...> >> 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 youit's> >> probably create a procedure that only returns the columns you need,>> >> >> 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" <hai21century@yahoo.com> wrote in message
> >> news:%23tvNidYrEHA.1964@TK2MSFTNGP12.phx.gbl...
> >> > 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
> >> >
> >> >
> >>
> >>
> >
>
Hai Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
