private void SearchExistingProducts() { int areaid = int.Parse(cmbArea2.SelectedValue.ToString()); int groupid = int.Parse(cmbGroup2.SelectedValue.ToString()); string productstring = txtProductID2.Text; string pagid = txtPAGID2.Text; DataSet ds = client.SQSAdmin_Promotion_GetExistingProductsForPromotion(promotionid, areaid, groupid, productstring, pagid); dataGrid2.DataContext = ds.Tables[0]; if (promotiontypeid != 11 && promotiontypeid != 10) { dataGrid2.Columns[6].Visibility = Visibility.Collapsed; dataGrid2.Columns[7].Visibility = Visibility.Collapsed; } else if (promotiontypeid != 11) { dataGrid2.Columns[7].Visibility = Visibility.Collapsed; } }