Re: Displaying Select columns(windows forms app)



Okay, I figured out how to filter out columns. I can't use ADO to do
it as it doesn't support such procedures with columns. What I do is
grab each value out of my dataset (of course skipping the ones I don't
want) and fill a 2-dimensional array. For anyone who's interested here
is the code.

Dim Ccount As Integer = dset1.Tables(0).Columns.Count
Dim Rcount As Integer = dset1.Tables(0).Rows.Count

'this is the number of columns I appened to end; its the
same every time
Const addr As Integer = 6

Dim notneed As Integer = Ccount - addr
Dim darray(Rcount, addr) As String

For i As Integer = 0 To 5
For x As Integer = 0 To (Rcount - 1)
For j As Integer = (notneed + 1) To (Ccount - 1)
darray(x, i) =
dset1.Tables(0).Rows.Item(x).Item(j)
Next
Next
Next

.



Relevant Pages

  • RE: OWC 11.0 - Subtotals return incorrect values
    ... Drag "Product Categories" natural hierarchy into the page filter area. ... Basically the totals don't match. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.olap)
  • Re: PGP Sigs on the Usenet (was: Re: Formatting Posts With VI)
    ... Is it indeed not possible to do filter them? ... Well, there is popular support for the notion, though without penalty, law ... valid basis for future consideration even if one does fail to win the day. ... of slrnpull capability, but it was my impression it was intended for dial-up ...
    (comp.os.linux.misc)
  • RE: Form Error when attempting to import MS Excel Spreadsheet
    ... Excel spreadsheet. ... I click okay again and the ... The server has been rebuilt fresh. ... >Microsoft Product Support Services ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Thinking of installing myself...
    ... You could just filter him..... ... Jim and Frank, Keep kicking his ass till the cows come home- but watch ... have been able to talk to me in Tech Support. ... dealer support, and what needs to be done to resolve issues. ...
    (alt.security.alarms)
  • Re: DataView RowFilter and Sort properties
    ... The system I'm working on allows many levels of applying filter, sorting ... After that, data is in DataTables, and the app will allow these to be ... and Sort properties to more fully support LIKE, ...
    (microsoft.public.dotnet.framework.adonet)

Quantcast