private void MDImainwnd_Load(object sender, EventArgs e)
{
try
{
int width = this.Width;
label1.Location = new Point(width - 300, label1.Location.Y);
dataGridViewRequirementlist.Location = new Point(width - 300, dataGridViewRequirementlist.Location.Y);
dataGridViewRequirementlist.Update();
string sqlqry = "select productdetails.itemname,SUM(productionorder.quantity) from productionorder,productdetails where productionorder.productID=productdetails.productID group by productdetails.itemname,productdetails.productID,productionorder.orderstatus having productionorder.orderstatus=0";
//string sqlqry = "select distinct productdetails.itemname,SUM(productionorder.quantity),count(product.productID) from product,productionorder,productdetails where productionorder.productID=productdetails.productID and product.productID=productionorder.productID group by product.salestatus,product.productID,productdetails.itemname,productdetails.productID,productionorder.orderstatus having productionorder.orderstatus=0 and product.salestatus='INSTOCK'";
SqlDataReader dr = dbConnection.query(sqlqry);
DataTable dt = new DataTable();
dt.Load(dr);
dataGridViewRequirementlist.DataSource = dt;
Login lgn = new Login();
lgn.ShowDialog();
dataGridViewRequirementlist.Columns[0].HeaderText = "Product Name";
dataGridViewRequirementlist.Columns[1].HeaderText = "Quantity Required";
}
catch
{
}
}
private void logoutToolStripMenuItem_Click(object sender, EventArgs e)
{
Login lgn = new Login();
lgn.MdiParent = MDImainwnd.ActiveForm;
lgn.Show();
}