SELECTING CERTAIN FIELDS IN A DATAGRID???

twyce · September 11th, 2008, 05:12 AM

Hi All
My code is already exporting datafrom a datagrid to an excel spreadsheet.My grid has student numbers and the modules they are registered for. example:
StudentID ModuleCode
s20600752 WIC2345
s20569875 POP3456
s20587466 TYU8765
s20569875 UYT6788

Now I want to be able to select a ModuleCode from the grid and only export students that are registered for that particular module.
Is this possible? please help?

Twyce!

DudTrap · November 14th, 2008, 02:22 PM

Code:

dim e as integer = 0
For e = 0 To yourdatagridname.RowCount - 1
            If yourdatagridname.Rows(e).Cells(cellnumber).Value = "specificmodulecode" Then
            'export the data you want here
            end if
Next

specificmodulecode is the module code you want to search for
yourdatagridname is the name of the grid
cellnumber is the cell you want to search

Try that

Dudtrap