Reporting from DataTable

[mcupito]

I have a DataTable that is populated from SELECT queries based on the parameters a user enters into text boxes. (First Name, Last Name or both)

I decrypt the values in the DataTable by using this code:

        Try
            For i As Integer = 0 To dt.Rows.Count - 1
                dt.Rows(i)("FIRST_NM_TXT") = clsEncrypt.DecryptData(dt.Rows(i)("FIRST_NM_TXT"))
                dt.Rows(i)("LAST_NM_TXT") = clsEncrypt.DecryptData(dt.Rows(i)("LAST_NM_TXT"))
            Next
        Catch ex As Exception
            MessageBox.Show("Either the first name or last name did not match. Please check your spelling.")
        End Try

How can I use the information inside the DataTable to create a report? The values must be decrypted.

I have done some researching and I am confused as to why so many people use DataSets as opposed to DataTables. DataSets are a collection of Tables, are they not?

Should I first be converting the DataTable into a DataSet, and then using that?

Here is my code that populates the DataTable.

 SqlCommand.Connection = SQLConnection 'Assigns connection to the command
 
 
 
        If SearchFirsttxt.Text = "" Then
            SqlCommand.CommandText = "Select * FROM PARTICIPANT WHERE LAST_NM_TXT = '" & eLast & "';"
        ElseIf SearchLastTxt.Text = "" Then
            SqlCommand.CommandText = "Select * FROM PARTICIPANT WHERE FIRST_NM_TXT = '" & eFirst & "';"
        ElseIf SearchFirsttxt.Text IsNot Nothing And SearchLastTxt.Text IsNot Nothing Then
            SqlCommand.CommandText = "Select * FROM PARTICIPANT WHERE FIRST_NM_TXT = '" & eFirst & "' and LAST_NM_TXT = '" & eLast & "';"
        Else
            SqlCommand.CommandText = "Select * FROM PARTICIPANT;"
        End If
 
 
        Dim myAdapter As New SqlDataAdapter(SqlCommand) 'holds the data
        myAdapter.Fill(dt) 'datatable that is populated into the holder (DataAdapter)
        DataGridView1.DataSource = dt 'Assigns source of information to the gridview (DataTable)

Thanks!