DataSet containing lookup values for Form Edit input fields. There should be one DataTable per lookup in this DataSet. See also AddEditLookup
The dataset should contain one or more DataTables, one for each lookup value.
The Lookup DataTable.TableName MUST have the same name as the Master table column name.
E.g. We want to have a lookup for the column ShipRegion in the Orders table in the Northwind database.
Dim dt As New DataTable("ShipRegion") ' Lookup DataTable.TableName=Master table column name
dt.Columns.Add("Value") ' The Value field for the lookup must be the first column, i.e. Column 0. The name of the column does not matter
dt.Columns.Add("Name") ' The Name field for the lookup must be in column 1
dt.Rows.Add(New String() {"", ""})
dt.Rows.Add(New String() {"RJ", "Rio de Janeiro"})
dt.Rows.Add(New String() {"SP", "Spain"})
AxpDataGrid1.LookupDataSet.Tables.Add(dt)
AxpDataGrid Class | Axezz.WebControls Namespace