ASP.NET

   Dim dtSearch As New DataTable<br />
<br />
dtSearch.Columns.Add("Table")<br />
            dtSearch.Columns.Add("Field")<br />
            dtSearch.Columns.Add("Operator")<br />
            dtSearch.Columns.Add("Standard Table")<br />
            dtSearch.Columns.Add("Value")<br />
            dtSearch.Columns.Add("And/Or")<br />
            dtSearch.Columns.Add("TempFieldName")<br />
            dtSearch.Columns.Add("TempDDLValue")<br />
<br />
 'Add new row<br />
        Dim dataRow As DataRow = dtSearch.NewRow()<br />
<br />
        dataRow(0) = radcTable.Text<br />
        Dim rowId As Integer = radcField.Value.Substring(0, 1)<br />
        Dim dt As DataTable = Reference.GeneralSearch.SelectFieldPropById(rowId)<br />
        dataRow(6) = dt.Rows(0).Item("FieldName").ToString<br />
        dt.Dispose()<br />
        dataRow(1) = radcField.Text<br />
        dataRow(2) = IIf(radcOperator.Text = "", "", radcOperator.Text)<br />
        dataRow(3) = IIf(radcStandardTable.Text = "Not Specified", "", radcStandardTable.Text)<br />
        dataRow(4) = txtValue.Text<br />
        dataRow(5) = ddlAndOr.SelectedValue<br />
        dataRow(7) = radcStandardTable.Value<br />
<br />
        dtSearch.Rows.Add(dataRow)<br />
<br />
 'sort datatable<br />
        ' datatable of non-sorted rows<br />
        Dim dsSorted As New DataSet<br />
        Dim Sort_Column_Key As String = "Table"<br />
        Dim Sort_Direction As String = "ASC"<br />
        Dim Sort_Format As String = "{0} {1}"<br />
<br />
        dtSearch.DefaultView.Sort = String.Format(Sort_Format, Sort_Column_Key, Sort_Direction)<br />
        dsSorted.Tables.Add(dtSearch.DefaultView.ToTable())<br />
<br />
        ViewState("dtSearch") = dtSearch<br />
<br />
        Dim gv As New GridView<br />
  dsSorted.Tables(0).Columns(6).ColumnMapping = MappingType.Hidden<br />
        dsSorted.Tables(0).Columns(7).ColumnMapping = MappingType.Hidden<br />
        dsSorted.AcceptChanges()<br />
<br />
        gv.DataSource = dsSorted<br />
 gv.DataBind()<br />
<br />
        Panel1.Controls.Add(gv)