I am currently trying to build an UltraGrid into my customization programmatically. The following is what I have. The first part builds the columns okay but when I try to add a row with data in it, that doesn’t show up. I’ve tried a few things with no luck. Can anyone see what I have wrong.
DataTable dtColumnHeaders = new DataTable(“Column Header Table”);
// Declare variables for DataColumn and DataRow objects.
DataColumn dcColumn;
// "Serial Number"
dcColumn = new DataColumn();
dcColumn.DataType = System.Type.GetType("System.Int32");
dcColumn.ColumnName = "SerialNumber";
dcColumn.Caption = "Serial Number";
dcColumn.ReadOnly = true;
dcColumn.Unique = true;
dtColumnHeaders.Columns.Add(dcColumn);
// "Date Created"
dcColumn = new DataColumn();
dcColumn.DataType = System.Type.GetType("System.Int32");
dcColumn.ColumnName = "DateCreated";
dcColumn.Caption = "Date Created";
dcColumn.ReadOnly = true;
dcColumn.Unique = true;
dtColumnHeaders.Columns.Add(dcColumn);
// "Consume"
dcColumn = new DataColumn();
dcColumn.DataType = System.Type.GetType("System.Int32");
dcColumn.ColumnName = "Consume";
dcColumn.Caption = "Consume";
dcColumn.ReadOnly = true;
dcColumn.Unique = true;
dtColumnHeaders.Columns.Add(dcColumn);
setgriddata dSetDataGrid = SetDataGrid;
DataGrid.Invoke(dSetDataGrid, DataGrid, dtColumnHeaders);
/************* Start building data row here ******************/
DataSet ds = new DataSet();
DataTable dt1 = new DataTable("Table");
DataGrid.DataSource = ds;
ds.Tables.Add(dt1);
DataColumn column1 = new DataColumn("Column 1", typeof(string));
DataColumn column2 = new DataColumn("Column 2", typeof(string));
DataColumn column3 = new DataColumn("Column 3", typeof(string));
//Add the three columns to the table.
dt1.Columns.AddRange(new DataColumn[] { column1, column2, column3 });
//Add the table to the dataset.
ds.Tables.Add(dt1);
UltraGridRow row = DataGrid.DisplayLayout.Bands[0].AddNew();
row.Cells[0].Value = "Plastic";
row.Cells[1].Value = "10/16/2020";
row.Cells[2].Value = "No";
DataGrid.DataSource = ds;