private void btnSearchBox_Click(object sender, EventArgs e)
{
SqlConnection sqlconn = new SqlConnection(SqlStatements.ConnectionString);
sqlconn.Open();
SqlCommand sqlcmd = new SqlCommand();
sqlcmd.Connection = sqlconn;
sqlcmd.CommandText = "Select [Stock Code], colour,finish,supplier from c_view_paint_box_list where [Box ID]=@boxId";
sqlcmd.Parameters.AddWithValue("@boxId", txtBoxID.Text);
SqlDataReader sdr = sqlcmd.ExecuteReader();
while (sdr.Read())
{
sc = Convert.ToInt32(sdr["Stock Code"]);
desc = sdr["Colour"] + " " + sdr["Finish"] + " " + sdr["Supplier"];
}
sdr.Close();
sqlcmd.Dispose();
frmPaintBoxes frmPB = new frmPaintBoxes(sc, desc);
frmPB.ShowDialog();
}
private void dgvPaintList_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dgvPaintList.SelectedCells.Count > 0)
{
int selectedrowindex = dgvPaintList.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = dgvPaintList.Rows[selectedrowindex];
sc = Convert.ToInt32(selectedRow.Cells["Stock Code"].Value);
desc = selectedRow.Cells["Colour"].Value + " " + selectedRow.Cells["Finish"].Value + " " + selectedRow.Cells["Supplier"].Value;
}
if (e.ColumnIndex == dgvPaintList.Columns["View Boxes"].Index)
{
frmPaintBoxes frmPB = new frmPaintBoxes(sc, desc);
frmPB.ShowDialog();
populatePaintList();
}
}
