private static void AddTextColumn(DataTable reportTable, String columnName, String caption)
{
var dc = new DataColumn(columnName);
dc.Caption = caption;
dc.ReadOnly = true;
dc.DataType = typeof(String);
dc.AllowResize = true;
dc.AllowSort = false;
dc.AllowReorder = false;
reportTable.Columns.Add(dc);
}
/// <summary>
/// Sample method to load random data into the grid
/// </summary>
public void LoadData()
{
// Create some sample names
List<string> firstNames = new List<string>() { "Peter", "Frank", "Joe", "Lewis", "Jack", "Andrew", "Susan", "Marie", "Linda", "Anne", "Claire", "Debra" };
List<string> lastNames = new List<string>() { "Smith", "Brown", "Green", "Parker", "Johnson", "Jackson", "Ford", "Sullivan" };
List<string> icons = new List<string>() { "UserGreen.png", "UserYellow.png", "UserRed.png" };
// Create a sample DataTable
DataTable dt = new DataTable("MyDataTable");
// Create a column
DataColumn dc1 = new DataColumn("col1");
dc1.Caption = "First Name";
dc1.ReadOnly = true;
dc1.DataType = typeof(String);
dc1.AllowResize = true;
dc1.AllowSort = true;
dc1.AllowReorder = true;
dt.Columns.Add(dc1);
// Create a column
DataColumn dc2 = new DataColumn("col2");
dc2.Caption = "Last Name";
dc2.ReadOnly = true;
dc2.DataType = typeof(String);
dc2.AllowResize = true;
dc2.AllowSort = true;
dc2.AllowReorder = true;
dt.Columns.Add(dc2);
// Create a column
DataColumn dc3 = new DataColumn("col3");
dc3.Caption = "Age";
dc3.ReadOnly = false;
dc3.DataType = typeof(Int32);
dt.Columns.Add(dc3);
// Create a column
DataColumn dc4 = new DataColumn("col4");
dc4.Caption = "Married";
dc4.ReadOnly = true;
dc4.DataType = typeof(Boolean);
dt.Columns.Add(dc4);
// Create a column
DataColumn dc5 = new DataColumn("col5");
dc5.Caption = "Membership expiration";
dc5.ReadOnly = true;
dc5.DataType = typeof(DateTime);
dt.Columns.Add(dc5);
// Create a column
DataColumn dc6 = new DataColumn("col6", typeof(Image));
dc6.Caption = "Status";
dc6.ReadOnly = true;
dt.Columns.Add(dc6);
// Add sample rows to the table
Random r = new Random();
for (int i = 0; i < 15; i++)
{
DataRow dr = new DataRow();
dr["col1"] = firstNames[r.Next(firstNames.Count)];
dr["col2"] = lastNames[r.Next(lastNames.Count)];
dr["col3"] = r.Next(20, 81);
dr["col4"] = (r.Next(0,2) == 1);
dr["col5"] = DateTime.Now.AddDays(r.Next(10));
Uri uri = new Uri("Images/" + icons[r.Next(icons.Count)], UriKind.RelativeOrAbsolute);
ImageSource imgSource = new BitmapImage(uri);
Image img = new Image();
img.ImageFailed += new EventHandler<ExceptionRoutedEventArgs>(img_ImageFailed);
img.Source = new BitmapImage(uri);
dr["col6"] = img;
dt.Rows.Add(dr);
}
// Create a DataSet and add the table to it
DataSet ds = new DataSet("MyDataSet");
ds.Tables.Add(dt);
// Do the binding
myBindableDG.AutoGenerateColumns = false;
myBindableDG.DataSource = ds;
myBindableDG.DataMember = "MyDataTable";
myBindableDG.DataBind();
// We could do this as well
// myBindableDG.DataSource = dt;
// myBindableDG.DataBind();
}
