private void FillProduct(String eventID)
{
string sqlEventText = "SELECT tblEventProduct.EventProductID, tblProduct.ProductName, tblProduct.ProductType " +
"FROM tblEventProduct INNER JOIN " +
"tblProduction ON tblEventProduct.ProductionID = tblProduction.ProductionID INNER JOIN " +
"tblProductItem ON tblProduction.ProductItemID = tblProductItem.ProductItemID INNER JOIN " +
"tblProductSize ON tblProductItem.SizeID = tblProductSize.SizeID INNER JOIN " +
"tblProduct ON tblProductItem.ProductID = tblProduct.ProductID " +
" WHERE tblEventProduct.EventID = " + eventID + " and tblEventProduct.Quantity > tblEventProduct.soldQuantity";
// Declare the connection
SqlConnection dbConnection = new SqlConnection(DBMethod.GetConnectionString());
// Create new SQL command
SqlCommand command = new SqlCommand(sqlEventText, dbConnection);
SqlDataAdapter adapter = new SqlDataAdapter(command);
// Declare a DataTable object that will hold the return value
DataTable productTable = new DataTable();
// Try to connect to the database, and use the adapter to fill the table
try
{
dbConnection.Open();
adapter.Fill(productTable);
cmbProduct.Items.Clear();
DBMethod.FillCombBoxPerson(productTable, cmbProduct);
}
catch (Exception ex)
{
}
finally
{
dbConnection.Close();
}
// Return the populated DataTable
}
