public void DisplayAllSOrders()
{
ClassLibrary.SupplierOrder sorder = new ClassLibrary.SupplierOrder();
dtSOrder = sorder.GetAll().Tables[0];
dataGridView1.DataSource = dtSOrder;
//set the parts id column as primary key so you can search the table later
dtSOrder.PrimaryKey = new DataColumn[] { dtSOrder.Columns["SORDER_id"] };
dataGridView1.Columns["SORDER_totalprice"].DefaultCellStyle.Format = "c";
dataGridView1.Columns["ORDER_id"].HeaderText = "Customer Order";
dataGridView1.Columns["SORDER_id"].HeaderText = "ID";
dataGridView1.Columns["SORDER_date"].HeaderText = "Date";
dataGridView1.Columns["SORDER_totalprice"].HeaderText = "Total Parts Price";
dataGridView1.Columns["SORDER_status"].HeaderText = "Status";
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
