Bunifu Datagrid View

using System;
using Bunifu.UI.WinForms;
using System.Drawing;
using System.Windows.Forms;

namespace BunifuGrid
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            BunifuDataGridView bunifuDataGridView = new BunifuDataGridView();
            bunifuDataGridView.Size = new Size(600, 250);
            bunifuDataGridView.Location = new Point(12, 28);
            this.Controls.Add(bunifuDataGridView);
            bunifuDataGridView.PopulateWithSampleData();
        }
    }
}

//set back color to the alternate row
bunifuDataGridView1.CurrentTheme.AlternatingRowsStyle.BackColor = Color.FromArgb(199, 226, 199);
//set text color to cells in the alternate row
bunifuDataGridView1.CurrentTheme.AlternatingRowsStyle.ForeColor = Color.Black;
//apply selection text color to cells im the alternate row
bunifuDataGridView1.CurrentTheme.AlternatingRowsStyle.SelectionForeColor = Color.White;
//set selection background color to the cells in the alternate row
bunifuDataGridView1.CurrentTheme.AlternatingRowsStyle.SelectionBackColor = Color.FromArgb(122, 185, 122);
//apply a font style to the cell's text in the alternate rows
bunifuDataGridView1.CurrentTheme.AlternatingRowsStyle.Font = new Font("Segoe UI", 10,FontStyle.Regular);

//apply back color to the row
bunifuDataGridView1.CurrentTheme.RowsStyle.BackColor = Color.FromArgb(210, 231, 210);
//apply text color to cells in the row
bunifuDataGridView1.CurrentTheme.RowsStyle.ForeColor = Color.Black;
//set selection text color to cells in the row
bunifuDataGridView1.CurrentTheme.RowsStyle.SelectionForeColor = Color.White;
//set selection background color to the cells in the row
bunifuDataGridView1.CurrentTheme.RowsStyle.SelectionBackColor = Color.FromArgb(122, 185, 122);
//apply a font style to the cell's text in the row
bunifuDataGridView1.CurrentTheme.RowsStyle.Font = new Font("Segoe UI", 10, FontStyle.Regular);

//apply back color to the column header
bunifuDataGridView1.CurrentTheme.HeaderStyle.BackColor = Color.ForestGreen;
//set text color to cells in the column header
bunifuDataGridView1.CurrentTheme.HeaderStyle.ForeColor = Color.White;
//set selection text color to cells in the column header
bunifuDataGridView1.CurrentTheme.HeaderStyle.SelectionForeColor = Color.White;
//apply selection background color to the cells in the column
bunifuDataGridView1.CurrentTheme.HeaderStyle.SelectionBackColor = Color.FromArgb(27, 111, 27);
//set a font style to the cell's text in the column header
bunifuDataGridView1.CurrentTheme.HeaderStyle.Font = new Font("Segoe UI", 10, FontStyle.Regular);
//set the column header height
bunifuDataGridView1.ColumnHeadersHeight = 36;

private void Form1_Load(object sender, EventArgs e)
{
    bunifuDataGridView1.Columns.AddRange(
    new DataGridViewTextBoxColumn()
    {
        HeaderText = "Product ID",
        Name = "productIDColumn"
    },
    new DataGridViewTextBoxColumn()
    {
        HeaderText = "Product Name",
        Name = "productNameColumn"
    },
    new DataGridViewTextBoxColumn()
    {
        HeaderText = "Customer Name",
        Name = "customerNameColumn"
    },
    new DataGridViewTextBoxColumn()
    {
        HeaderText = "Country",
        Name = "countryColumn"
    },
    new DataGridViewTextBoxColumn()
    {
        HeaderText = "Shipping City",
        Name = "shippingCityColumn"
    }
    );
}

DataGridViewColumn dataGridViewColumn = bunifuDataGridView1.Columns[0];
//or
DataGridViewColumn gridViewColumn = bunifuDataGridView1.Columns["productIDColumn"];

//remove the second column
bunifuDataGridView1.Columns.RemoveAt(1);
//or
bunifuDataGridView1.Columns.Remove(gridViewColumn);
//clear all columns
bunifuDataGridView1.Columns.Clear();

class Order
{
    public string ProductId { get; set; }
    public string ProductName { get; set; }
    public string CustomerName { get; set; }
    public string Country { get; set; }
    public string ShippingCity{ get; set; }
}

using System;
using System.Collections.Generic;
using System.Windows.Forms;
namespace Example2
{
private void Form1_Load(object sender, EventArgs e)
{
	List<Order> orderList = new List<Order>()
	{
		new Order()
		{
			ProductId = "#01293",
			ProductName = "HP Envy x360",
			CustomerName = "Dylan Gray",
			Country = "Portugal",
			ShippingCity = "Spain"
		},
		new Order()
		{
			ProductId = "#01294",
			ProductName = "Seagate SSDs",
			CustomerName = "Sarah Banks",
			Country = "United States",
			ShippingCity = "New York"
		},
		new Order()
		{
			ProductId = "#01295",
			ProductName = "HP Envy x360",
			CustomerName = "Tracy Rivera",
			Country = "Kenya",
			ShippingCity = "Nairobi"
		}
	};
foreach (var order in orderList)
{
	bunifuDataGridView1.Rows.Add(order.ProductId,order.ProductName,order.CustomerName,order.Country,order.ShippingCity);
}
}
}

//Modify the value in the second cell of the third row.
bunifuDataGridView1.Rows[2].Cells[1].Value = "Dell AlienWare M17 R4";
// The previous line is equivalent to the following line.  
bunifuDataGridView1[1,2].Value= "Dell AlienWare M17 R4";

for(int i = 0; i < bunifuDataGridView1.Rows.Count; i++)
{
    //Modify the backcolor, the fore color and selection color in every cell of the FIRST column
    bunifuDataGridView1[1, i].Style.BackColor = Color.FromArgb(152, 175, 92);
    bunifuDataGridView1[1, i].Style.ForeColor = Color.White;
    bunifuDataGridView1[1, i].Style.SelectionBackColor = Color.FromArgb(63, 137, 90);
    //Modify the backcolor, the fore color and selection color every cell of the THIRD column
    bunifuDataGridView1[4, i].Style.BackColor = Color.FromArgb(152, 175, 92);
    bunifuDataGridView1[4, i].Style.ForeColor = Color.White;
    bunifuDataGridView1[4, i].Style.SelectionBackColor = Color.FromArgb(63, 137, 90);
}

private void bunifuButton1_Click(object sender, EventArgs e)
{
    //get the number of the selected rows
    int selectedRows = bunifuDataGridView1.Rows.GetRowCount(DataGridViewElementStates.Selected);
           
    if (selectedRows > 0)
    {
        StringBuilder cellValuesStringBuilder = new StringBuilder();
        //loop through each of the selected row
        for(int i = 0; i < selectedRows; i++)
        {
            //loop the cells of a row, get their values and append them in a string builder
            for (int j = 0; j < bunifuDataGridView1.ColumnCount; j++)
            {
                cellValuesStringBuilder.Append(bunifuDataGridView1.SelectedRows[i].Cells[j].Value+"\t");
            }
            //create a new line for the next row loop
            cellValuesStringBuilder.Append("\n");
        }
        //print the output on a console
        Console.WriteLine(cellValuesStringBuilder);
    }
}

private void bunifuButton1_Click(object sender, EventArgs e){
//get the number of selected cells
int selectedCells = bunifuDataGridView1.GetCellCount(DataGridViewElementStates.Selected);

if (selectedCells > 0)
{
    StringBuilder cellStrBuilder = new StringBuilder();
    //loop through the selected cells, get their values and append to the string builder variable
    for(int i = 0; i < selectedCells; i++)
    {
        cellStrBuilder.Append(bunifuDataGridView1.SelectedCells[i].Value + "\t");
    }
    //output the seleccted cell values
    Console.WriteLine(cellStrBuilder);
}

private void Form3_Load(object sender, EventArgs e)
{
		 for (int i = 0; i < bunifuDataGridView1.Columns.Count; i++)
		 {
				//set the sort mode for all the textbox columns
				bunifuDataGridView1.Columns(i).SortMode = DataGridViewColumnSortMode.Programmatic;
		 }
		  bunifuDataGridView1.SelectionMode = DataGridViewSelectionMode.ColumnHeaderSelect;
}
private void bunifuButton1_Click(object sender, EventArgs e)
{		// get the selected cells in the column
		  int selectedCells = bunifuDataGridView1.GetCellCount(DataGridViewElementStates.Selected);
		  StringBuilder strBuider = new StringBuilder();

		  for (int i = 0; i < selectedCells; i++)
		  {
				//get the selected cell values from the column
				strBuider.Append(bunifuDataGridView1.SelectedCells(i).Value + "\t");
		  }
				//output the selected values
			Console.WriteLine(strBuider);
}

//the event gets fired when the mouse is over the cell
private void bunifuDataGridView1_CellMouseEnter(object sender, DataGridViewCellEventArgs e)
{
    /*
        * check whether the mouse is over the row cells of the datagrid.
        * this avoids the code below from executing when the mouse hovers on the column header cells and row header cells
    */
    if(e.ColumnIndex >= 0 & e.RowIndex >= 0)
    {
        //get the row datagrid cell currently hovered
        DataGridViewCell dataGridcell = bunifuDataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex];
        //get the display area or the location of the cell that is currently hovered
        var cellreactangle = bunifuDataGridView1.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, true);
        //check whether the cell has text content in it
        if (dataGridcell.Value != null)
        {
            //use bunifu tooltip to display the text content of the cell
             bunifuToolTip1.Show(bunifuDataGridView1, dataGridcell.Value.ToString(), bunifuDataGridView1.Columns[dataGridcell.ColumnIndex].HeaderText, null, bunifuDataGridView1.PointToScreen(new Point(cellreactangle.X + 80, cellreactangle.Y)));
        }
    }   
}
private void bunifuDataGridView1_CellMouseLeave(object sender, DataGridViewCellEventArgs e)
{
    bunifuToolTip1.Hide();
}

class OrderDemo
{
    private Guid order_Id=Guid.NewGuid();

    public Guid OrderID
      {
        get { return order_Id; }
        set { order_Id = value; }
      }
    public string ProductName { get; set; }
    public string CustomerName { get; set; }
    public string PhoneNumber { get; set; }
    public string ShippingCity { get; set; } 
}

//the global variable provides the source of data for the Datagrid and where the generic list will be bound
BindingSource bindingSource = new BindingSource();
//the form load event containing out BunifuDataGridView
private void Form1_Load(object sender, EventArgs e)
{
    /*
      *the BindingList class is of type OrderDemo
      *has support to provide binding capabilities for a generic list
    */
    BindingList<OrderDemo> orderDemoList = new BindingList<OrderDemo>()
    {
        //add the class objects to the list, setting their properties
        new OrderDemo()
        {
            CustomerName="Tracy Ravis",
            PhoneNumber="(188)1863076",
            ShippingCity="Salt Lake City",
            ProductName="HP Envy x360 13 (2020)"
        },
        new OrderDemo()
        {
            CustomerName="Elsie Harris",
            PhoneNumber="(046)1938785",
            ShippingCity="Perth",
            ProductName="HP Envy 13 (2021)"
        },
        new OrderDemo()
        {
            CustomerName="Roger Craig",
            PhoneNumber="(042)9830172",
            ShippingCity="Australian Capital Territory",
            ProductName="HP Spectre x360 14"
        },
        new OrderDemo()
        {
            CustomerName="Danny Mckinney",
            PhoneNumber="(651)0438562",
            ShippingCity="Glendale",
            ProductName="HP EliteBook x360 1040 G7"
        },
        new OrderDemo()
        {
            CustomerName="Derrick Wade",
            PhoneNumber="(636)4728149",
            ShippingCity="San Bernardino",
            ProductName="HP Chromebook x2"
        }
    };
    //bind the list to the binding source
    bindingSource.DataSource = orderDemoList;
    //set the binding source as the data source for Bunifu DataGrid View
    bunifuDataGridView1.DataSource = bindingSource;
}

class OrderDemo
{
    private Guid order_Id=Guid.NewGuid();

    public Guid OrderID
      {
        get { return order_Id; }
        set { order_Id = value; }
      }
    public string ProductName { get; set; }
    public string CustomerName { get; set; }
    public string PhoneNumber { get; set; }
    public string ShippingCity { get; set; } 
}

private void Form5_Load(object sender, EventArgs e)
{

    BindingList<OrderDemo> orderDemoList = new BindingList<OrderDemo>()
    {

        new OrderDemo()
        {
            CustomerName="Tracy Ravis",
            PhoneNumber="(188)1863076",
            ShippingCity="Salt Lake City",
            ProductName="HP Envy x360 13 (2020)"
        },
        new OrderDemo()
        {
            CustomerName="Elsie Harris",
            PhoneNumber="(046)1938785",
            ShippingCity="Perth",
            ProductName="HP Envy 13 (2021)"
        },
        new OrderDemo()
        {
            CustomerName="Roger Craig",
            PhoneNumber="(042)9830172",
            ShippingCity="Australian Capital Territory",
            ProductName="HP Spectre x360 14"
        },
        new OrderDemo()
        {
            CustomerName="Danny Mckinney",
            PhoneNumber="(651)0438562",
            ShippingCity="Glendale",
            ProductName="HP EliteBook x360 1040 G7"
        },
        new OrderDemo()
        {
            CustomerName="Derrick Wade",
            PhoneNumber="(636)4728149",
            ShippingCity="San Bernardino",
            ProductName="HP Chromebook x2"
        }
    };
}

DataTable dataTable = new DataTable();
//create an array of table columns
DataColumn[] tableColumns = new DataColumn[]
{
    new DataColumn()
    {
        ColumnName="Order_ID",
        DataType=typeof(string),
    },
    new DataColumn()
    {
        ColumnName="Product Name",
        DataType=typeof(string),
    },
    new DataColumn()
    {
        ColumnName="Customer Name",
        DataType=typeof(string),
    },
    new DataColumn()
    {
        ColumnName="Phone Number",
        DataType=typeof(string),
    },
    new DataColumn()
    {
        ColumnName="Shipping City",
        DataType=typeof(string),
    }

};    
dataTable.Columns.AddRange(tableColumns);
//loop through the  each of the order objects in the list and get their prop values
foreach(var data in orderDemoList)
{
    dataTable.Rows.Add(data.OrderID, data.ProductName, data.CustomerName, data.PhoneNumber, data.ShippingCity);
}
//bind the data table to Bunifu DataGridView
bunifuDataGridView1.DataSource = dataTable;

<?xml version="1.0" encoding="utf-8" ?>
<Invoice>
    <Item>
      <Item_Number>001</Item_Number>
      <Item_Name>MacBook Air</Item_Name>
      <Item_Price>$999</Item_Price>
    </Item>
    <Item>
      <Item_Number>002</Item_Number>
      <Item_Name>MacBook Pro 13</Item_Name>
      <Item_Price>$999</Item_Price>
    </Item>
    <Item>
      <Item_Number>003</Item_Number>
      <Item_Name>MacBook Pro 16”</Item_Name>
      <Item_Price>$999</Item_Price>
    </Item>
    <Item>
      <Item_Number>004</Item_Number>
      <Item_Name>Iphone 12 Pro</Item_Name>
      <Item_Price>$999</Item_Price>
    </Item>
    <Item>
      <Item_Number>005</Item_Number>
      <Item_Name>Iphone 12</Item_Name>
      <Item_Price>$699</Item_Price>
    </Item>
    <Item>
      <Item_Number>006</Item_Number>
      <Item_Name>Iphone 11</Item_Name>
      <Item_Price>$599</Item_Price>
    </Item>
</Invoice>

private void Form6_Load(object sender, EventArgs e)
{
    DataSet dataSet = new DataSet();
    //get the current directory path
    string currentPath = Directory.GetCurrentDirectory();
    //get two folders up to the assembly folder
    string newPath = Path.GetFullPath(Path.Combine(currentPath, @"..\..\"));
    //get the xml file
    dataSet.ReadXml(newPath + @"/InvoiceXML.xml");
    //bind the xml to Bunifu DataGridView
    bunifuDataGridView1.DataSource = dataSet.Tables[0];
}

private void Form1_Load(object sender, EventArgs e)
{
  //instantiate the entity created from the wizard
  BuniEntities buniEntities = new BuniEntities();
  //load the table data from the database
  buniEntities.Orders.Load();//use System.Data.Entity for the load method
 
   //bind the data to Bunifu DataGridView
  /*the local property provides access to the data 
   * without a query being sent to the database
  */
  bunifuDataGridView1.DataSource = buniEntities.Orders.Local.ToBindingList();
}

private void bunifuDataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
    //get the cell that has the primary key
    int primaryKey= Convert.ToInt32(bunifuDataGridView1.Rows[e.RowIndex].Cells[0].Value);

    //get the column name where the cell is currently modified
    string columnName = bunifuDataGridView1.Columns[e.ColumnIndex].HeaderText;

    //get the cell value modified
    string editedValue = bunifuDataGridView1[e.ColumnIndex, e.RowIndex].Value.ToString();
   
    switch (columnName)
    {

        case "ProductName":
            //update the entity model object with a new value
            buniEntities.Orders.Find(primaryKey).ProductName = editedValue;
            //save the changes in the database
            buniEntities.SaveChanges();
            bunifuSnackbar1.Show(this, "Changes effected on one row", BunifuSnackbar.MessageTypes.Information, 1200, null, BunifuSnackbar.Positions.MiddleCenter);
            break;
        case "CustomerName":
            buniEntities.Orders.Find(primaryKey).CustomerName = editedValue;
            buniEntities.SaveChanges();
            bunifuSnackbar1.Show(this, "Changes effected on one row", BunifuSnackbar.MessageTypes.Information, 1200, null, BunifuSnackbar.Positions.MiddleCenter);
            break;
        case "ShippingCity":
            buniEntities.Orders.Find(primaryKey).ShippingCity = editedValue;
            bunifuSnackbar1.Show(this, "Changes effected on one row", BunifuSnackbar.MessageTypes.Information, 1200, null, BunifuSnackbar.Positions.MiddleCenter);
            buniEntities.SaveChanges();
            break;
        case "State":
            buniEntities.Orders.Find(primaryKey).State = editedValue;
            buniEntities.SaveChanges();
            break;
        case "Quantity":
            buniEntities.Orders.Find(primaryKey).Quantity = Convert.ToInt32(editedValue);
            bunifuSnackbar1.Show(this, "Changes effected on one row", BunifuSnackbar.MessageTypes.Information, 1200, null, BunifuSnackbar.Positions.MiddleCenter);
            buniEntities.SaveChanges();
            break;
        case "UnitPrice":
            buniEntities.Orders.Find(primaryKey).UnitPrice = Convert.ToInt32(editedValue);
            buniEntities.SaveChanges();
            bunifuSnackbar1.Show(this, "Changes effected on one row", BunifuSnackbar.MessageTypes.Information, 1200, null, BunifuSnackbar.Positions.MiddleCenter);
            break;
        default:
            break;
    }
  
}

private void Form6_Load(object sender, EventArgs e)
    {
        //instantiate the entity created from the wizard
        BuniEntities buniEntities = new BuniEntities();
        //execute the sql query to retrieve the data
        var ordersData= buniEntities.Database.SqlQuery<BunifuData.Order>("Select * From Orders").ToList();
        //bind the retrieved data to the datagrid view
        bunifuDataGridView1.DataSource = ordersData;
    }

using Micron;
static void Main()
{    //the connection configuration file
    MicronConfig connectionConfig = new MicronConfig()
    {
        Host="localhost",
        User="root",
        Password="",
        Port="8080",
        DatabaseName="inventory"
    };
    MicronDbContext.AddConnectionSetup(connectionConfig);
}

private void Form1_Load(object sender, EventArgs e)
{   //create the db context to access data from the database     
    MicronDbContext dbContext = new MicronDbContext();
    //retrieve data from the customer table
    var customers = dbContext.GetRecords<Data.Models.Customer>();
    //bind the data to Bunifu DataGridView
    bunifuDataGridView1.DataSource = customers.Select(x => new {
        x.CustomerID,
        x.CustomerName,
        x.ContactName,
        x.City,
        x.Country
    }).ToList();
}
}

 private void bunifuButton1_Click(object sender, EventArgs e)
 {
     /*add a label control from the form
      * this will take all the property styles used in the label
      * and apply them in the report
     */
     bunifuReports1.AddControl(titleBunifuLabel);
     //add some line breaks to create a space before rendering the next control
     bunifuReports1.AddLineBreak();
     bunifuReports1.AddLineBreak();
     /*
      * add Bunifu DataGridView control to the form
      * with the use of the AddDataGridView method
      * the first parameter is the Datagrid control
      * while the second parameter is the customization of the control rendered 
      * in the report
     */
     bunifuReports1.AddDatagridView(bunifuDataGridView1, "border=0;");
     //instantiate the save file dialog class to save the report as a pdf
     SaveFileDialog saveFile = new SaveFileDialog();
     //add the save file dialog component to the form
     this.components.Add(saveFile);
     //add a save as file type filter
     saveFile.Filter = "PDF(*.pdf)|*.pdf";
     //display the dialog and execute the code below when the ok button is pressed
    if(saveFile.ShowDialog() == DialogResult.OK)
     {
         //get the path where the pdf file will be saved
         string path = Path.GetFullPath(saveFile.FileName);
         //use the SavePDF method of Bunifu reports component to save the file
         //inside the method we shall pass the path  where the pdf will be saved
         bunifuReports1.SavePDF(path);
     }
}