private void button1_Click(object sender, EventArgs e) { textBox1.Text = ""; comboBox1.SelectedIndex = -1; MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnection(); string myConnectionString; myConnectionString = "server=127.0.0.1;" + "uid=root;" + "pwd=root;" + "SslMode=none;" + "database=db"; var a = new EquipmentUI(); a.dataGridView1.DefaultCellStyle.SelectionBackColor = a.dataGridView1.DefaultCellStyle.BackColor; a.dataGridView1.DefaultCellStyle.SelectionForeColor = a.dataGridView1.DefaultCellStyle.ForeColor; conn.ConnectionString = myConnectionString; conn.Open(); using (MySqlConnection con = new MySqlConnection(myConnectionString)) { using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,items.name,items.stocks FROM items ", conn)) { cmd.CommandType = CommandType.Text; using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd)) { using (DataTable dt = new DataTable()) { sda.Fill(dt); (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DataSource = dt; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ReadOnly = false; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ClearSelection(); (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[2].Visible = false; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Value = "Name"; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[4].Visible = false; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].HeaderCell.Value = ""; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].Width = 50; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].HeaderCell.Value = ""; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].Width = 50; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Refresh(); } } } } }
private void Form3_Load(object sender, EventArgs e) { var a = new EquipmentUI(); MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnection(); string myConnectionString; myConnectionString = "server=127.0.0.1;" + "uid=root;" + "pwd=root;" + "SslMode=none;" + "database=db"; conn.ConnectionString = myConnectionString; conn.Open(); using (MySqlConnection con = new MySqlConnection(myConnectionString)) { using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,items.name,items.stocks,category.description,items.description,items.isDeployable,items.isDamaged,items.isOnrepair,items.isRented,items.isDeployed,items.isDamagedBeyondRepair FROM items left join category on items.categoryID = category.id where items.id =" + EquipmentUI.sendtext, conn)) { cmd.CommandType = CommandType.Text; using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd)) { MySqlDataReader myreader = cmd.ExecuteReader(); if (myreader.Read()) { Label2.Text = myreader.GetValue(1).ToString(); Label4.Text = myreader.GetValue(3).ToString(); Label8.Text = myreader.GetValue(2).ToString(); if (myreader.GetValue(4).ToString() == "") { Label6.Text = "Not specified"; } else { Label6.Text = myreader.GetValue(4).ToString(); } Label13.Text = myreader.GetValue(5).ToString(); Label14.Text = myreader.GetValue(6).ToString(); Label15.Text = myreader.GetValue(7).ToString(); Label16.Text = myreader.GetValue(8).ToString(); dep.Text = myreader.GetValue(9).ToString(); dbr.Text = myreader.GetValue(10).ToString(); this.Text = myreader.GetValue(1).ToString(); } myreader.Close(); } } } conn.Close(); }
public void Form1_Load(object sender, EventArgs e) { MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnection(); string myConnectionString; myConnectionString = "server=127.0.0.1;" + "uid=root;" + "pwd=root;" + "SslMode=none;" + "database=db"; var a = new EquipmentUI(); dataGridView1.DefaultCellStyle.SelectionBackColor = dataGridView1.DefaultCellStyle.BackColor; dataGridView1.DefaultCellStyle.SelectionForeColor = dataGridView1.DefaultCellStyle.ForeColor; conn.ConnectionString = myConnectionString; conn.Open(); using (MySqlConnection con = new MySqlConnection(myConnectionString)) { using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,items.name,items.stocks FROM items ", conn)) { cmd.CommandType = CommandType.Text; using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd)) { using (DataTable dt = new DataTable()) { sda.Fill(dt); dataGridView1.DataSource = dt; dataGridView1.ReadOnly = false; dataGridView1.ClearSelection(); dataGridView1.Columns[2].Visible = false; dataGridView1.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns[3].HeaderCell.Value = "Name"; dataGridView1.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns[4].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns[4].HeaderCell.Value = "Stock"; dataGridView1.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns[1].HeaderCell.Value = ""; dataGridView1.Columns[1].Width = 50; dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns[0].HeaderCell.Value = ""; dataGridView1.Columns[0].Width = 50; dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dataGridView1.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; } } } } }
private void Form3_Load(object sender, EventArgs e) { dataGridView1.ClearSelection(); dataGridView2.ClearSelection(); dataGridView3.ClearSelection(); dataGridView4.ClearSelection(); var a = new EquipmentUI(); MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnection(); string myConnectionString; myConnectionString = "server=127.0.0.1;" + "uid=root;" + "pwd=root;" + "SslMode=none;" + "database=db"; conn.ConnectionString = myConnectionString; conn.Open(); using (MySqlConnection con = new MySqlConnection(myConnectionString)) { using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,items.name,items.stocks,category.description,items.description,items.isDeployable,items.isDamaged,items.isOnrepair,items.isRented,items.isDeployed,items.isDamagedBeyondRepair FROM items left join category on items.categoryID = category.id where items.id =" + EquipmentUI.sendtext, conn)) { cmd.CommandType = CommandType.Text; using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd)) { MySqlDataReader myreader = cmd.ExecuteReader(); if (myreader.Read()) { Label2.Text = myreader.GetValue(1).ToString(); Label4.Text = myreader.GetValue(3).ToString(); if (myreader.GetValue(4).ToString() == "") { Label6.Text = "Not specified"; } else { Label6.Text = myreader.GetValue(4).ToString(); } this.Text = myreader.GetValue(1).ToString(); } myreader.Close(); } } } conn.Close(); conn.ConnectionString = myConnectionString; conn.Open(); using (MySqlConnection con = new MySqlConnection(myConnectionString)) { using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,itemcontent.modelNumber,itemcontent.id from items left join itemcontent on items.id = itemcontent.itemID where items.id =" + EquipmentUI.sendtext + " and itemcontent.tagID < 2", conn)) { cmd.CommandType = CommandType.Text; using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd)) { using (DataTable dt = new DataTable()) { sda.Fill(dt); dataGridView1.DataSource = dt; dataGridView1.ClearSelection(); dataGridView1.Columns[2].Visible = false; dataGridView1.Columns[4].Visible = false; dataGridView1.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns[3].HeaderCell.Value = "Name / Model Number"; dataGridView1.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns[3].DefaultCellStyle.ForeColor = Color.Black; dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns[1].HeaderCell.Value = ""; dataGridView1.Columns[1].Width = 50; dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView1.Columns[0].HeaderCell.Value = ""; dataGridView1.Columns[0].Width = 50; dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; } } } } conn.Close(); conn.ConnectionString = myConnectionString; conn.Open(); using (MySqlConnection con = new MySqlConnection(myConnectionString)) { using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,itemcontent.modelNumber,itemcontent.id,damagelogs.datedamaged from items left join itemcontent on items.id = itemcontent.itemID inner JOIN damagelogs on itemcontent.id = damagelogs.itemid where items.id =" + EquipmentUI.sendtext + " and itemcontent.tagID = 2 and damagelogs.datedamaged != '0000-00-00'", conn)) { //SELECT damagelogs.daterdamaged,itemcontent.modelNumber from repairlogs inner JOIN itemcontent on itemcontent.id = repairlogs.itemID where itemcontent.itemID = " + EquipmentUI.sendtext + " and repairlogs.daterepaired != '0000-00-00' cmd.CommandType = CommandType.Text; using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd)) { using (DataTable dt = new DataTable()) { sda.Fill(dt); dataGridView2.DefaultCellStyle.SelectionBackColor = Color.Transparent; dataGridView2.DefaultCellStyle.SelectionForeColor = Color.Transparent; dataGridView2.DataSource = dt; dataGridView2.ClearSelection(); dataGridView2.Columns[1].Visible = false; dataGridView2.Columns[3].Visible = false; dataGridView2.Columns[2].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView2.Columns[2].HeaderCell.Value = "Name / Model Number"; dataGridView2.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView2.Columns[2].DefaultCellStyle.ForeColor = Color.Black; dataGridView2.Columns[4].DefaultCellStyle.ForeColor = Color.Black; dataGridView2.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView2.Columns[1].HeaderCell.Value = ""; dataGridView2.Columns[1].Width = 50; dataGridView2.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView2.Columns[0].HeaderCell.Value = ""; dataGridView2.Columns[0].Width = 100; dataGridView2.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dataGridView2.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dataGridView2.Columns[4].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView2.Columns[4].HeaderCell.Value = "Date & Time"; dataGridView2.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; } } } } conn.Close(); conn.ConnectionString = myConnectionString; conn.Open(); using (MySqlConnection con = new MySqlConnection(myConnectionString)) { using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,itemcontent.modelNumber,itemcontent.id from items left join itemcontent on items.id = itemcontent.itemID where items.id =" + EquipmentUI.sendtext + " and itemcontent.tagID = 3", conn)) { cmd.CommandType = CommandType.Text; using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd)) { using (DataTable dt = new DataTable()) { sda.Fill(dt); dataGridView3.DataSource = dt; dataGridView3.ClearSelection(); dataGridView3.Columns[1].Visible = false; dataGridView3.Columns[3].Visible = false; dataGridView3.Columns[2].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView3.Columns[2].HeaderCell.Value = "Name / Model Number"; dataGridView3.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView3.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView3.Columns[1].HeaderCell.Value = ""; dataGridView3.Columns[1].Width = 50; dataGridView3.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView3.Columns[0].HeaderCell.Value = ""; dataGridView3.Columns[0].Width = 100; dataGridView3.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; } } } } conn.Close(); conn.ConnectionString = myConnectionString; conn.Open(); using (MySqlConnection con2 = new MySqlConnection(myConnectionString)) { using (MySql.Data.MySqlClient.MySqlCommand cmd2 = new MySql.Data.MySqlClient.MySqlCommand("SELECT repairlogs.daterepaired,itemcontent.modelNumber from repairlogs inner JOIN itemcontent on itemcontent.id = repairlogs.itemID where itemcontent.itemID = " + EquipmentUI.sendtext + " and repairlogs.daterepaired != '0000-00-00'", conn)) { cmd2.CommandType = CommandType.Text; using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd2)) { using (DataTable dt = new DataTable()) { sda.Fill(dt); dataGridView4.DataSource = dt; dataGridView4.ClearSelection(); dataGridView4.Columns[1].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView4.Columns[1].HeaderCell.Value = "Name / Model Number"; dataGridView4.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView4.Columns[1].DefaultCellStyle.ForeColor = Color.Black; dataGridView4.Columns[0].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView4.Columns[0].HeaderCell.Value = "Date & Time"; dataGridView4.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; dataGridView4.Columns[0].DefaultCellStyle.ForeColor = Color.Black; dataGridView4.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; dataGridView4.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; } } } } }
private void textBox1_TextChanged(object sender, EventArgs e) { var a = new EquipmentUI(); var t = int.Parse(comboBox1.SelectedIndex.ToString()); var i = t + 1; if (comboBox1.Text.Equals("")) { MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnection(); string myConnectionString; myConnectionString = "server=127.0.0.1;" + "uid=root;" + "pwd=root;" + "SslMode=none;" + "database=db"; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionBackColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.BackColor; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionForeColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.ForeColor; conn.ConnectionString = myConnectionString; conn.Open(); using (MySqlConnection con = new MySqlConnection(myConnectionString)) { using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,items.name,items.stocks FROM items where items.name like '%" + textBox1.Text + "%'", conn)) { cmd.CommandType = CommandType.Text; using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd)) { using (DataTable dt = new DataTable()) { sda.Fill(dt); (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DataSource = dt; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ReadOnly = false; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ClearSelection(); (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[2].Visible = false; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Value = "Name"; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].HeaderCell.Value = ""; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].Width = 50; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].HeaderCell.Value = ""; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].Width = 50; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Refresh(); } } } } } if (comboBox1.Text != "") { MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnection(); string myConnectionString; myConnectionString = "server=127.0.0.1;" + "uid=root;" + "pwd=root;" + "SslMode=none;" + "database=db"; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionBackColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.BackColor; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionForeColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.ForeColor; conn.ConnectionString = myConnectionString; conn.Open(); using (MySqlConnection con = new MySqlConnection(myConnectionString)) { using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,items.name,items.stocks,items.categoryID FROM items where items.name like '%" + textBox1.Text + "%' and items.categoryID=" + i, conn)) { cmd.CommandType = CommandType.Text; using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd)) { using (DataTable dt = new DataTable()) { sda.Fill(dt); (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DataSource = dt; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ReadOnly = false; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ClearSelection(); (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[2].Visible = false; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Value = "Name"; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].HeaderCell.Value = ""; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].Width = 50; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].HeaderCell.Value = ""; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].Width = 50; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Refresh(); } } } } } if (comboBox1.Text.Equals("")) { var a1 = ""; MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnection(); string myConnectionString; myConnectionString = "server=127.0.0.1;" + "uid=root;" + "pwd=root;" + "SslMode=none;" + "database=db"; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionBackColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.BackColor; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionForeColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.ForeColor; conn.ConnectionString = myConnectionString; conn.Open(); using (MySqlConnection con = new MySqlConnection(myConnectionString)) { using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,items.name FROM items where items.name like '%" + textBox1.Text + "%' ", conn)) { cmd.CommandType = CommandType.Text; using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd)) { using (DataTable dt = new DataTable()) { sda.Fill(dt); (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DataSource = dt; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ReadOnly = false; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ClearSelection(); (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[2].Visible = false; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Value = "Name"; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].HeaderCell.Value = ""; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].Width = 50; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].HeaderCell.Value = ""; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].Width = 50; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Refresh(); } } } } } if (comboBox1.Text != "" && textBox1.Text != "") { var a1 = ""; MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnection(); string myConnectionString; myConnectionString = "server=127.0.0.1;" + "uid=root;" + "pwd=root;" + "SslMode=none;" + "database=db"; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionBackColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.BackColor; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionForeColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.ForeColor; conn.ConnectionString = myConnectionString; conn.Open(); using (MySqlConnection con = new MySqlConnection(myConnectionString)) { using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,items.name FROM items where items.name like '%" + textBox1.Text + "%' and items.categoryID=" + i, conn)) { cmd.CommandType = CommandType.Text; using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd)) { using (DataTable dt = new DataTable()) { sda.Fill(dt); (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DataSource = dt; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ReadOnly = false; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ClearSelection(); (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[2].Visible = false; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Value = "Name"; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; // (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[4].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; // (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[4].HeaderCell.Value = "Stock"; //(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].HeaderCell.Value = ""; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].Width = 50; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].HeaderCell.Value = ""; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].Width = 50; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; //(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Refresh(); } } } } } if (comboBox1.Text != "" && textBox1.Text == "") { var a1 = ""; MySql.Data.MySqlClient.MySqlConnection conn = new MySqlConnection(); string myConnectionString; myConnectionString = "server=127.0.0.1;" + "uid=root;" + "pwd=root;" + "SslMode=none;" + "database=db"; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionBackColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.BackColor; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.SelectionForeColor = (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DefaultCellStyle.ForeColor; conn.ConnectionString = myConnectionString; conn.Open(); using (MySqlConnection con = new MySqlConnection(myConnectionString)) { using (MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("SELECT items.id,items.name FROM items where items.categoryID=" + i, conn)) { cmd.CommandType = CommandType.Text; using (MySqlDataAdapter sda = new MySqlDataAdapter(cmd)) { using (DataTable dt = new DataTable()) { sda.Fill(dt); (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.DataSource = dt; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ReadOnly = false; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.ClearSelection(); (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[2].Visible = false; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].HeaderCell.Value = "Name"; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; //(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[4].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; // (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[4].HeaderCell.Value = "Stock"; // (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[4].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].HeaderCell.Value = ""; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[1].Width = 50; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].HeaderCell.Value = ""; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[0].Width = 50; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; //(System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; (System.Windows.Forms.Application.OpenForms["EquipmentUI"] as EquipmentUI).dataGridView1.Refresh(); } } } } } }