private Exception UpdateOrderSheetTable(DataGridView dataGridView, string type)
        {
            try
            {
                DataTable dt = new DataTable();
                dt = (DataTable)dataGridView.DataSource;
                string text = orderSheetHandler.GetOrderSheets(type);
                string text2 = orderSheetHandler.GetUpdateCommand(type);

                SqlControl.OpenConnection(text);
                SqlControl.SqlDataAdapter.UpdateCommand = new MySqlCommand(text2);
                SqlControl.SqlDataAdapter.UpdateCommand.Connection = SqlControl.Connection;
                SqlControl.SqlDataAdapter.DeleteCommand =
                    new MySqlCommand(String.Format(@"delete from {0}order_sheets where order_sheets_id = @order_sheets_id", type), SqlControl.Connection);
                SqlControl.SqlDataAdapter.DeleteCommand.Parameters.Add("order_sheets_id", MySqlDbType.Int16, 0, "order_sheets_id").SourceVersion = DataRowVersion.Original;
                SqlControl.SqlDataAdapter.UpdateCommand.Parameters.Add("upc_number", MySqlDbType.VarChar, 13, "upc_number");
                SqlControl.SqlDataAdapter.UpdateCommand.Parameters.Add("catalog_number", MySqlDbType.VarChar, 15, "catalog_number");
                SqlControl.SqlDataAdapter.UpdateCommand.Parameters.Add("label_studio_name", MySqlDbType.VarChar, 35, "label_studio_name");
                SqlControl.SqlDataAdapter.UpdateCommand.Parameters.Add("artist_name", MySqlDbType.VarChar, 30, "artist_name");
                SqlControl.SqlDataAdapter.UpdateCommand.Parameters.Add("item_title", MySqlDbType.VarChar, 50, "item_title");
                SqlControl.SqlDataAdapter.UpdateCommand.Parameters.Add("vendor_number", MySqlDbType.VarChar, 6, "vendor_number");
                SqlControl.SqlDataAdapter.UpdateCommand.Parameters.Add("month_code", MySqlDbType.VarChar, 6, "month_code");
                SqlControl.SqlDataAdapter.UpdateCommand.Parameters.Add("year_code", MySqlDbType.VarChar, 6, "year_code");
                SqlControl.SqlDataAdapter.UpdateCommand.Parameters.Add("price", MySqlDbType.VarChar, 6, "price");
                SqlControl.SqlDataAdapter.UpdateCommand.Parameters.Add("reorder_number", MySqlDbType.VarChar, 6, "reorder_number");
                SqlControl.SqlDataAdapter.UpdateCommand.Parameters.Add("qty", MySqlDbType.Int16, 0, "qty");
                SqlControl.SqlDataAdapter.UpdateCommand.Parameters.Add("order_sheets_id", MySqlDbType.Int16, 0, "order_sheets_id");
                SqlControl.SqlDataAdapter.Update(dt);
                SqlControl.SqlDataAdapter.Dispose();
                log.Info(String.Format("[UpdateOrderSheetTable] type: {0} update successful", type));
            }
            catch (Exception ex)
            {
                log.Error(String.Format("[UpdateOrderSheetTable] type: {0} update failed.\r\n{1}", type, ex.Message));
                return ex;
            }
            return null;
        }