deleting columns which are not necessary using datetime pickers.

[kodandekod]

Hello,
I have a datagridview with column names as dates.
e.g.

Name 1/1/2001 2/1/2001 3/1/2001 4/1/2001 5/1/2001

name1 2krona 4krona 7krona 8krona 21krona

name2 12krona 32krona 66krona 44krona 333krona

name3 1krona 23krona 3 krona 99krona 2krona

i adding 2 datepickers one for from date and the other for to date.

when click the from date as 2/1/2001 and to date as 4/1/2001. i need the result as


Name 2/1/2001 3/1/2001 4/1/2001
name1 4krona 7krona 8krona

name2 32krona 66krona 44krona

name3 23krona 3 krona 99krona

it must work 4 many values.

 

[ss7thirty]

Each column has a name property and you could convert that column to a date and based on that value hide or leave that column.

        Dim dc As DataGridViewColumn
        For Each dc In DataGridView1.Columns
            Dim dtVal As Date = CDate(dc.Name)
            If dtVal < pickedDate Then
                dc.Visible = False
            End If
        Next

Also just make sure you skip the columns that cannot be converted to date values because an exception will occur there.