private void LoadData()
{
//Setup Rows
OutlookGridRow row = new OutlookGridRow();
List<OutlookGridRow> l = new List<OutlookGridRow>();
OutlookGrid1.SuspendLayout();
OutlookGrid1.ClearInternalRows();
OutlookGrid1.FillMode = FillMode.GroupsAndNodes;
List<Token> tokensList = new List<Token>();
tokensList.Add(new Token("Best seller", Color.Orange, Color.Black));
tokensList.Add(new Token("New", Color.LightGreen, Color.Black));
tokensList.Add(null);
tokensList.Add(null);
tokensList.Add(null);
Random random = new Random();
//.Next permet de retourner un nombre aléatoire contenu dans la plage spécifiée entre parenthèses.
XmlDocument doc = new XmlDocument();
doc.Load("invoices.xml");
IFormatProvider culture = new CultureInfo("en-US", true);
foreach (XmlNode customer in doc.SelectNodes("//invoice")) //TODO for instead foreach for perfs...
{
try
{
row = new OutlookGridRow();
row.CreateCells(OutlookGrid1, new object[] {
customer["CustomerID"].InnerText,
customer["CustomerName"].InnerText,
customer["Address"].InnerText,
customer["City"].InnerText,
new TextAndImage(customer["Country"].InnerText,GetFlag(customer["Country"].InnerText)),
DateTime.Parse(customer["OrderDate"].InnerText,culture),
customer["ProductName"].InnerText,
double.Parse(customer["Price"].InnerText, CultureInfo.InvariantCulture), //We put a float the formatting in design does the rest
(double)random.Next(101) /100,
tokensList[random.Next(5)]
});
if (random.Next(2) == 1)
{
//Sub row
OutlookGridRow row2 = new OutlookGridRow();
row2.CreateCells(OutlookGrid1, new object[] {
customer["CustomerID"].InnerText + " 2",
customer["CustomerName"].InnerText + " 2",
customer["Address"].InnerText + "2",
customer["City"].InnerText + " 2",
new TextAndImage(customer["Country"].InnerText,GetFlag(customer["Country"].InnerText)),
DateTime.Now,
customer["ProductName"].InnerText + " 2",
(double)random.Next(1000),
(double)random.Next(101) /100,
tokensList[random.Next(5)]
});
row.Nodes.Add(row2);
((KryptonDataGridViewTreeTextCell)row2.Cells[1]).UpdateStyle(); //Important : after added to the parent node
}
l.Add(row);
((KryptonDataGridViewTreeTextCell)row.Cells[1]).UpdateStyle(); //Important : after added to the rows list
}
catch (Exception ex)
{
MessageBox.Show("Gasp...Something went wrong ! " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
OutlookGrid1.ResumeLayout();
OutlookGrid1.AssignRows(l);
OutlookGrid1.ForceRefreshGroupBox();
OutlookGrid1.Fill();
}
