private void partToolStripMenuItem_Click(object sender, EventArgs e)
{
frmPart fmPart = new frmPart();
fmPart.MdiParent = this;
fmPart.Show();
fmPart.WindowState = FormWindowState.Maximized;
fmPart.Focus();
}
private void frmPart_Load(object sender, EventArgs e)
{
frmPart fp = new frmPart();
fp.WindowState = FormWindowState.Maximized;
DBConnect dbconnect = new DBConnect();
dbconnect.connection.Open();
MySqlCommand command = new MySqlCommand();
command.Connection = dbconnect.connection;
string qry;
qry = "select parts.id, parts.part_name,parts.number, inventory.quantity from parts LEFT JOIN inventory ON parts.ID =inventory.part_id order by parts.id asc;";
command.CommandText = qry;
DataTable data = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter(command);
adapter.Fill(data);
dataGridView1.DataSource = data;
}