private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + sCompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
if (PurchaseID != "")
{
dt = oMySql.GetDataView(String.Format("Select PaymentID, Comment, Date, Amount,Type from PaymentProvider Where CompanyID='{0}' And PurchaseID='{1}' Order By Date", sCompanyID, PurchaseID), "Tmp");
}
else
{
dt = oMySql.GetDataView(String.Format("Select PaymentID, Comment, Date, Amount,Type from PaymentProvider Where CompanyID='{0}' Order By Date", sCompanyID), "Tmp");
}
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + CompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
if (this.CustomerID.Trim() == "")
{
dt = oMySql.GetDataView(String.Format("Select CustomerID,Teacher, BatchID, Scanned from {0} Where CompanyID='" + this.CompanyID + "'", "OrderScanned"), "Teachers");
}
else
{
dt = oMySql.GetDataView(String.Format("Select CustomerID,Teacher, BatchID, Scanned from {0} Where CompanyID='" + this.CompanyID + "' And CustomerID='" + this.CustomerID + "' ", "OrderScanned"), "Teachers");
}
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + sCompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
//dt = oMySql.get_customer_dataview(this.sCompanyID);
if (!IsPending)
{
dt = oMySql.GetDataView(String.Format("Select PurchaseID, v.Name, Date from Purchase p Left Join Vendor v on p.CompanyID=v.CompanyID And p.VendorID=v.VendorID Where p.CompanyID='{0}'", sCompanyID), "Tmp");
}
else
{
dt = oMySql.GetDataView(String.Format("CALL get_pending_PO('{0}')", sCompanyID), "Tmp");
}
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + sCompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
dt = oMySql.GetDataView("SELECT PrizeID, Description, Prize_Break, Levels from Prizes Where CompanyID='" + sCompanyID + "'", "Prize");
DataGridTableStyle TbStyle = new DataGridTableStyle();
TbStyle.MappingName = "Prize";
TbStyle.RowHeadersVisible = false;
TbStyle.GridLineColor = System.Drawing.Color.Black;
TbStyle.AllowSorting = false;
TbStyle.AlternatingBackColor = System.Drawing.Color.AliceBlue;
DataGridTextBoxColumn Col_01 = new DataGridTextBoxColumn();
Col_01.HeaderText = "Prize ID";
Col_01.MappingName = "PrizeID";
Col_01.Width = 60;
Col_01.NullText = "";
Col_01.ReadOnly = true;
Col_01.Alignment = System.Windows.Forms.HorizontalAlignment.Center;
DataGridTextBoxColumn Col_02 = new DataGridTextBoxColumn();
Col_02.HeaderText = "Description";
Col_02.MappingName = "Description";
Col_02.Width = 70;
Col_02.NullText = "";
Col_02.ReadOnly = true;
DataGridTextBoxColumn Col_03 = new DataGridTextBoxColumn();
Col_03.HeaderText = "PrizeBreak";
Col_03.MappingName = "PrizeBreak";
Col_03.Width = 70;
Col_03.NullText = "";
Col_03.ReadOnly = true;
DataGridTextBoxColumn Col_04 = new DataGridTextBoxColumn();
Col_03.HeaderText = "Levels";
Col_03.MappingName = "Leves";
Col_03.Width = 70;
Col_03.NullText = "";
Col_03.ReadOnly = true;
TbStyle.GridColumnStyles.AddRange(new DataGridColumnStyle[] { Col_01, Col_02, Col_03, Col_04 });
DataGrid.TableStyles.Add(TbStyle);
DataGrid.DataSource = dt;
//DataGrid.Focus();
this.txtSearch.Focus();
//oMySql.Close();
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + sCompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
if (CustomerID.Trim() == "")
{
dt = oMySql.GetDataView(String.Format("Select distinct(Teacher), count(Student)as Students,CustomerID from {0} Where CompanyID='" + this.sCompanyID + "' Group by Teacher", "Orders"), "Teachers");
}
else
{
dt = oMySql.GetDataView(String.Format("Select distinct(Teacher), count(Student)as Students,CustomerID from {0} Where CompanyID='" + this.sCompanyID + "' And CustomerID='" + this.CustomerID + "' Group by Teacher", "Orders"), "Teachers");
}
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + sCompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
dt = oMySql.GetDataView("SELECT CustomerID, Name, City, State from Customer Where CompanyID='" + sCompanyID + "'", "Customer");
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmViewTeacher_Load(object sender, System.EventArgs e)
{
Signature.Data.MySQL oMySql = Global.oMySql;
dt = oMySql.GetDataView("SELECT r.ID, r.Rep_ID, rs.Name, User FROM user r Left Join Reps rs On rs.ID=r.Rep_ID Order By User,rs.Name", "Rep");
//cboTraineeFields.Items.Insert(0, "Teacher");
//cboTraineeFields.Items.Insert(1, "Students");
//cboTraineeFields.SelectedIndex = 0;
//
DataGridTableStyle TbStyle = new DataGridTableStyle();
TbStyle.MappingName = "Rep";
TbStyle.RowHeadersVisible = false;
TbStyle.GridLineColor = System.Drawing.Color.Black;
TbStyle.AllowSorting = false;
TbStyle.AlternatingBackColor = System.Drawing.Color.AliceBlue;
DataGridTextBoxColumn Col_00 = new DataGridTextBoxColumn();
Col_00.HeaderText = "Rep ID";
Col_00.MappingName = "ID";
Col_00.Width = 80;
Col_00.NullText = "";
Col_00.ReadOnly = true;
DataGridTextBoxColumn Col_01 = new DataGridTextBoxColumn();
Col_01.HeaderText = "User";
Col_01.MappingName = "User";
Col_01.Width = 80;
Col_01.NullText = "";
Col_01.ReadOnly = true;
DataGridTextBoxColumn Col_02 = new DataGridTextBoxColumn();
Col_02.HeaderText = "Name";
Col_02.MappingName = "Name";
Col_02.Width = 200;
Col_02.NullText = "";
Col_02.ReadOnly = true;
TbStyle.GridColumnStyles.AddRange(new DataGridColumnStyle[] { Col_00, Col_01, Col_02 });
DataGrid.TableStyles.Add(TbStyle);
DataGrid.DataSource = dt;
//DataGrid.Focus();
//oMySql.Close();
GroupBox1.Focus();
txtSearch.Focus();
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
Signature.Data.MySQL oMySql = Global.oMySql;
dt = oMySql.GetDataView("Select d.BrochureID,d.Description from Brochure d Where CompanyID='" + sCompanyID + "'", "Brochures");
this.Text = "Brochure View";
//
/* //'.Items.Insert(0, "School ID")
* cboTraineeFields.Items.Insert(0, "Name");
* cboTraineeFields.Items.Insert(1, "Address");
* //'.Items.Insert(3, "ChairPerson")
* cboTraineeFields.SelectedIndex = 0;
*/
//
DataGridTableStyle TbStyle = new DataGridTableStyle();
TbStyle.MappingName = "Brochures";
TbStyle.RowHeadersVisible = false;
TbStyle.GridLineColor = System.Drawing.Color.Black;
TbStyle.AllowSorting = false;
TbStyle.AlternatingBackColor = System.Drawing.Color.AliceBlue;
DataGridTextBoxColumn Col_01 = new DataGridTextBoxColumn();
Col_01.HeaderText = "Brochure ID";
Col_01.MappingName = "BrochureID";
Col_01.Width = 45;
Col_01.NullText = "";
Col_01.ReadOnly = true;
Col_01.Alignment = System.Windows.Forms.HorizontalAlignment.Center;
DataGridTextBoxColumn Col_02 = new DataGridTextBoxColumn();
Col_02.HeaderText = "Description";
Col_02.MappingName = "Description";
Col_02.Width = 225;
Col_02.NullText = "";
Col_02.ReadOnly = true;
/* DataGridTextBoxColumn Col_03 = new DataGridTextBoxColumn();
*
* Col_03.HeaderText = "Address";
* Col_03.MappingName = "Address";
* Col_03.Width = 225;
* Col_03.NullText = "";
* Col_03.ReadOnly = true;
*/
TbStyle.GridColumnStyles.AddRange(new DataGridColumnStyle[] { Col_01, Col_02 });
DataGrid.TableStyles.Add(TbStyle);
DataGrid.DataSource = dt;
//DataGrid.Focus();
this.txtSearch.Focus();
//oMySql.Close();
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + sCompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
//dt = oMySql.GetDataView(String.Format("Select ChargeID, Comment, Date, Amount,Type from Payment Where CompanyID='{0}' And CustomerID='{1}' Order By Date",sCompanyID,CustomerID), "Tmp");
dt = oMySql.GetDataView("SELECT r.RepID, rs.Name FROM Rep r Left Join Reps rs On rs.ID=r.ID Where CompanyID='" + sCompanyID + "' order by rs.Name", "Reps");
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void LoadTickets()
{
//CONVERT(, CHAR(8)) AS ID
Signature.Data.MySQL oMySql = Global.oMySql;
if (this.OrderID == 0)
{
dt = oMySql.GetDataView(String.Format("SELECT CONVERT(ot.OrderID, CHAR(8)) as ID, CONVERT(ot.ID, CHAR(8)) AS TicketID , o.Student, o.CustomerID FROM OrderTicket ot Left Join Orders o On o.ID=ot.OrderID Where ot.CompanyID='{0}'", this.sCompanyID), "Tickets");
}
else
{
dt = oMySql.GetDataView(String.Format("SELECT CONVERT(ot.OrderID, CHAR(8)) as ID, CONVERT(ot.ID, CHAR(8)) AS TicketID , o.Student, o.CustomerID FROM OrderTicket ot Left Join Orders o On o.ID=ot.OrderID Where ot.OrderID='{0}' And ot.ProductID='{1}'", this.OrderID, this.ProductID), "Tickets");
}
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + sCompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
dt = oMySql.GetDataView(String.Format("Select r.Reference, ReceiveID, r.Date, r.PurchaseID, v.Name from Receive r Left join Purchase p on r.PurchaseID=p.PurchaseID And r.CompanyID=p.CompanyID Left join Vendor v on p.VendorID=v.VendorID And p.CompanyID=v.CompanyID Where p.CompanyID='{0}' Order By r.Date DESC ", sCompanyID), "Tmp");
//dt = oMySql.GetDataView(String.Format("CALL get_pending_PO('{0})", sCompanyID), "Tmp");
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + sCompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
// String Sql = String.Format("Select PurchaseNoteID as ID, Date, Note from PurchaseNotes Where CompanyID='{0}' And PurchaseID='{1}'", sCompanyID, PurchaseID);
dt = oMySql.GetDataView(String.Format("Select PurchaseNoteID as ID, DATE_FORMAT(Date,'%m/%d/%y %H:%m:%S') as Date, Note from PurchaseNotes Where CompanyID='{0}' And PurchaseID='{1}'", sCompanyID, PurchaseID), "Tmp");
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + sCompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
if (OrderID.Trim() != "")
{
dt = oMySql.GetDataView(String.Format("Select ShortageID, CustomerID, OrderID, Name, City, Detail from Shortage Where CompanyID='{0}' And OrderID='{1}'", sCompanyID, OrderID), "Tmp");
}
else if (CustomerID.Trim() != "")
{
dt = oMySql.GetDataView(String.Format("Select ShortageID, CustomerID, OrderID, Name, City, Detail from Shortage Where CompanyID='{0}' And CustomerID='{1}' And OrderID='0'", sCompanyID, CustomerID), "Tmp");
}
else
{
dt = oMySql.GetDataView(String.Format("Select ShortageID, CustomerID, OrderID, Name, City, Detail from Shortage Where CompanyID='{0}'", sCompanyID), "Tmp");
}
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + CompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
if (this.CustomerID.Trim() == "")
{
dt = oMySql.GetDataView("Select distinct(Student) as Name, Teacher, sum(Nro_Items)as NoItems, CustomerID from Orders Where CompanyID='" + this.CompanyID + "' Group by Student,Teacher", "Students");
}
else if (this.Teacher.Trim() == "")
{
dt = oMySql.GetDataView("Select distinct(Student) as Name, Teacher, sum(Nro_Items)as NoItems, CustomerID from Orders Where CompanyID='" + this.CompanyID + "' And CustomerID='" + this.CustomerID + "' Group by Student,Teacher", "Students");
}
else
{
dt = oMySql.GetDataView("Select distinct(Student) as Name, Teacher, sum(Nro_Items)as NoItems, CustomerID from Orders Where CompanyID='" + this.CompanyID + "' And CustomerID='" + this.CustomerID + "' And Teacher='" + this.Teacher + "' Group by Student,Teacher", "Students");
}
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + sCompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
dt = oMySql.GetDataView(String.Format("SELECT * FROM CardTemplate"), "CardTemplate");
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + sCompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
dt = oMySql.GetDataView(String.Format("SELECT CardSetID, Start, End, TotalCredit FROM WLOT.cart_cardsets"), "CardSet");
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + CompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
dt = oMySql.GetDataView(String.Format("Select distinct(os.CustomerID), c.Name from OrderScanned os Left Join Customer c on os.CompanyID=c.CompanyID And os.CustomerID=c.CustomerID Where os.CompanyID='" + this.CompanyID + "'", "OrderScanned"), "Customers");
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
contextMenu1 = new System.Windows.Forms.ContextMenu();
System.Windows.Forms.MenuItem menuItem1;
menuItem1 = new System.Windows.Forms.MenuItem();
System.Windows.Forms.MenuItem menuItem2;
menuItem2 = new System.Windows.Forms.MenuItem();
System.Windows.Forms.MenuItem menuItem3;
menuItem3 = new System.Windows.Forms.MenuItem();
contextMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] { menuItem1, menuItem2, menuItem3 });
menuItem1.Index = 0;
menuItem1.Text = "View";
menuItem2.Index = 1;
menuItem2.Text = "Modify";
menuItem3.Index = 2;
menuItem3.Text = "Delete";
menuItem1.Click += new EventHandler(this.menuitem1_Click);
//textBox1.ContextMenu = contextMenu1;
//txtSearch.ContextMenu = contextMenu1;
Grid.ContextMenu = contextMenu1;
//
Signature.Data.MySQL oMySql = Global.oMySql;
if (this.All)
{
dt = oMySql.GetDataView("SELECT CompanyID, Name FROM Company Order By CompanyID", "Company");
}
else
{
dt = oMySql.GetDataView("SELECT CompanyID, Name FROM Company where IsExternal='0' Order By CompanyID", "Company");
}
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmViewTeacher_Load(object sender, System.EventArgs e)
{
Signature.Data.MySQL oMySql = Global.oMySql;
dt = oMySql.GetDataView("SELECT VendorID, Name FROM Vendor Where CompanyID='" + _CompanyID + "'", "Vendor");
//cboTraineeFields.Items.Insert(0, "Teacher");
//cboTraineeFields.Items.Insert(1, "Students");
//cboTraineeFields.SelectedIndex = 0;
//
DataGridTableStyle TbStyle = new DataGridTableStyle();
TbStyle.MappingName = "Vendor";
TbStyle.RowHeadersVisible = false;
TbStyle.GridLineColor = System.Drawing.Color.Black;
TbStyle.AllowSorting = false;
TbStyle.AlternatingBackColor = System.Drawing.Color.AliceBlue;
DataGridTextBoxColumn Col_01 = new DataGridTextBoxColumn();
Col_01.HeaderText = "Vendor ID";
Col_01.MappingName = "VendorID";
Col_01.Width = 80;
Col_01.NullText = "";
Col_01.ReadOnly = true;
DataGridTextBoxColumn Col_02 = new DataGridTextBoxColumn();
Col_02.HeaderText = "Name";
Col_02.MappingName = "Name";
Col_02.Width = 200;
Col_02.NullText = "";
Col_02.ReadOnly = true;
TbStyle.GridColumnStyles.AddRange(new DataGridColumnStyle[] { Col_01, Col_02 });
DataGrid.TableStyles.Add(TbStyle);
DataGrid.DataSource = dt;
DataGrid.Focus();
//oMySql.Close();
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
contextMenu1 = new System.Windows.Forms.ContextMenu();
System.Windows.Forms.MenuItem menuItem1;
menuItem1 = new System.Windows.Forms.MenuItem();
System.Windows.Forms.MenuItem menuItem2;
menuItem2 = new System.Windows.Forms.MenuItem();
System.Windows.Forms.MenuItem menuItem3;
menuItem3 = new System.Windows.Forms.MenuItem();
contextMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] { menuItem1, menuItem2, menuItem3 });
menuItem1.Index = 0;
menuItem1.Text = "View";
menuItem2.Index = 1;
menuItem2.Text = "Modify";
menuItem3.Index = 2;
menuItem3.Text = "Delete";
menuItem1.Click += new EventHandler(this.menuitem1_Click);
//textBox1.ContextMenu = contextMenu1;
//txtSearch.ContextMenu = contextMenu1;
Grid.ContextMenu = contextMenu1;
//
this.Text += " - " + sCompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
dt = oMySql.GetDataView(String.Format("SELECT user, RepID FROM mailserver.virtual_users Where domain_id='{0}'", this.DomainID), "Domains");
this.txtSearch.Focus();
Grid.DataSource = dt;
}
private void frmCustomerView_Load(object sender, System.EventArgs e)
{
this.Text += " - " + sCompanyID;
Signature.Data.MySQL oMySql = Global.oMySql;
dt = oMySql.GetDataView("SELECT BoxID, Length, Width, Height,ProductID from BoxSize Where CompanyID='" + sCompanyID + "'", "Box");
//
/* //'.Items.Insert(0, "School ID")
* cboTraineeFields.Items.Insert(0, "Name");
* cboTraineeFields.Items.Insert(1, "Address");
* //'.Items.Insert(3, "ChairPerson")
* cboTraineeFields.SelectedIndex = 0;
*/
//
DataGridTableStyle TbStyle = new DataGridTableStyle();
TbStyle.MappingName = "Box";
TbStyle.RowHeadersVisible = false;
TbStyle.GridLineColor = System.Drawing.Color.Black;
TbStyle.AllowSorting = false;
TbStyle.AlternatingBackColor = System.Drawing.Color.AliceBlue;
DataGridTextBoxColumn Col_01 = new DataGridTextBoxColumn();
Col_01.HeaderText = "Box ID";
Col_01.MappingName = "BoxID";
Col_01.Width = 60;
Col_01.NullText = "";
Col_01.ReadOnly = true;
Col_01.Alignment = System.Windows.Forms.HorizontalAlignment.Center;
DataGridTextBoxColumn Col_02 = new DataGridTextBoxColumn();
Col_02.HeaderText = "Length";
Col_02.MappingName = "Length";
Col_02.Width = 70;
Col_02.NullText = "";
Col_02.ReadOnly = true;
DataGridTextBoxColumn Col_03 = new DataGridTextBoxColumn();
Col_03.HeaderText = "Width";
Col_03.MappingName = "Width";
Col_03.Width = 70;
Col_03.NullText = "";
Col_03.ReadOnly = true;
DataGridTextBoxColumn Col_04 = new DataGridTextBoxColumn();
Col_03.HeaderText = "Height";
Col_03.MappingName = "Height";
Col_03.Width = 70;
Col_03.NullText = "";
Col_03.ReadOnly = true;
DataGridTextBoxColumn Col_05 = new DataGridTextBoxColumn();
Col_03.HeaderText = "Item#";
Col_03.MappingName = "ProductID";
Col_03.Width = 120;
Col_03.NullText = "";
Col_03.ReadOnly = true;
TbStyle.GridColumnStyles.AddRange(new DataGridColumnStyle[] { Col_01, Col_02, Col_03, Col_04, Col_05 });
DataGrid.TableStyles.Add(TbStyle);
DataGrid.DataSource = dt;
//DataGrid.Focus();
this.txtSearch.Focus();
//oMySql.Close();
}
public DataView Orders(String CompanyID, String CustomerID, String Name, OrderType Type)
{
DataView _Orders = oMySql.GetDataView("SELECT * FROM signatv9_osas.orders Where CompanyID=\"" + CompanyID + "\" And CustomerID=\"" + CustomerID + "\" And Teacher=\"" + Name + "\" And OrderType=" + ((int)Type).ToString(), "Orders");
return(_Orders);
}
private void frmViewTeacher_Load(object sender, System.EventArgs e)
{
Signature.Data.MySQL oMySql = Global.oMySql;
//dt = oMySql.GetDataView("SELECT ID, Teacher, Student, Scanned, Packed FROM Orders Where CompanyID='"+sCompanyID+ "' And CustomerID='"+sCustomerID+"' And (BoxesPacked!=0 And BoxesPacked!=BoxesScanned)","Tmp");
dt = oMySql.GetDataView(String.Format("SELECT o.ID, o.Teacher,o.Student,ol.Scanned, ol.Packed FROM Orders o Left Join OrderByLine ol On o.ID=ol.OrderID Where o.CompanyID='{0}' And CustomerID='{1}' And ol.PackID='{2}' And (ol.Packed<>'1' Or ol.Scanned <>'1') And o.Teacher NOT Like '%A INTERNET%'", Global.CurrrentCompany, this.sCustomerID, Global.CurrrentLine), "Tmp");
//cboTraineeFields.Items.Insert(0, "Teacher");
//cboTraineeFields.Items.Insert(1, "Students");
//cboTraineeFields.SelectedIndex = 0;
//
DataGridTableStyle TbStyle = new DataGridTableStyle();
TbStyle.MappingName = "Tmp";
TbStyle.RowHeadersVisible = false;
TbStyle.GridLineColor = System.Drawing.Color.Black;
TbStyle.AllowSorting = false;
TbStyle.AlternatingBackColor = System.Drawing.Color.AliceBlue;
DataGridTextBoxColumn Col_01 = new DataGridTextBoxColumn();
Col_01.HeaderText = "Order ID";
Col_01.MappingName = "ID";
Col_01.Width = 50;
Col_01.NullText = "";
Col_01.ReadOnly = true;
DataGridTextBoxColumn Col_02 = new DataGridTextBoxColumn();
Col_02.HeaderText = "Teacher Name";
Col_02.MappingName = "Teacher";
Col_02.Width = 150;
Col_02.NullText = "";
Col_02.ReadOnly = true;
DataGridTextBoxColumn Col_03 = new DataGridTextBoxColumn();
Col_03.HeaderText = "Student Name";
Col_03.MappingName = "Student";
Col_03.Width = 150;
Col_03.NullText = "";
Col_03.ReadOnly = true;
DataGridTextBoxColumn Col_04 = new DataGridTextBoxColumn();
Col_04.HeaderText = "Packed";
Col_04.MappingName = "Packed";
Col_04.Width = 50;
Col_04.NullText = "";
Col_04.ReadOnly = true;
DataGridTextBoxColumn Col_05 = new DataGridTextBoxColumn();
Col_05.HeaderText = "Scanned";
Col_05.MappingName = "Scanned";
Col_05.Width = 50;
Col_05.NullText = "";
Col_05.ReadOnly = true;
TbStyle.GridColumnStyles.AddRange(new DataGridColumnStyle[] { Col_01, Col_02, Col_03, Col_04, Col_05 });
DataGrid.TableStyles.Add(TbStyle);
DataGrid.DataSource = dt;
DataGrid.Focus();
//oMySql.Close();
}
