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(); }