or
((GridViewComboBoxColumn)((RadGridView)sender).Columns["ActivityTypeID"]).ItemsSource = ComboBoxValues.GetComboValues(dtActivityType.Select("ID < 2000")); |
We are using the Radtreeview control in our Query Builder application to show the Tables and Fields from the Dtabase . The user can drag and drop the fields in to Selection list (select clause - listbox) and Condition list (where clause - listbox). When i drag and drop the field in to Selection list or Condition list, the selected treeview item(field) removed from the RadTreeView. I want to use the same field in both the lists.
Thanks,
private void BindDataMainGrid() |
{ |
try |
{ |
GridViewTableDefinition BudgetTableDefinition = new GridViewTableDefinition(); |
BudgetTableDefinition.Relation = new PropertyRelation("Budget"); |
GridViewTableDefinition SubBudgetTableDefinition = new GridViewTableDefinition(); |
SubBudgetTableDefinition.Relation = new PropertyRelation("SubBudget"); |
this.gvAccount.ItemsSource = this.GetData(); |
} |
catch{} |
} |
private void OnChildGridLoaded(object sender, RoutedEventArgs e) |
{ |
try |
{ |
var dataRowView = (DataRowView)((RadGridView)sender).ParentRow.DataContext; |
var ds = dataRowView.DataView.Table.DataSet; |
var childData = dataRowView.CreateChildView(ds.Relations["BudgetRelation"]); |
//סינון הערכים בגריד לפי סוג פעילות |
if (((ComboBoxValues.ComboValues)cmbActivityType.SelectedValue).Id != 0) |
{ |
childData.RowFilter = "ActivityTypeID=" + ((ComboBoxValues.ComboValues)cmbActivityType.SelectedValue).Id; |
((RadGridView)sender).ItemsSource = childData; |
} |
else |
{ |
((RadGridView)sender).ItemsSource = null; |
((RadGridView)sender).ItemsSource = childData; |
} |
//סינון הערכים בתיבת הבחירה בעמודה של סוג פעילות |
if (Convert.ToInt32(dataRowView.Row.ItemArray[5]) == 1) |
{ |
((GridViewComboBoxColumn)((RadGridView)sender).Columns["ActivityTypeID"]).ItemsSource = ComboBoxValues.GetComboValues(dtActivityType.Select("ID < 2000")); |
} |
if (Convert.ToInt32(dataRowView.Row.ItemArray[5]) == 2) |
{ |
((GridViewComboBoxColumn)((RadGridView)sender).Columns["ActivityTypeID"]).ItemsSource = ComboBoxValues.GetComboValues(dtActivityType.Select("ID > 2000")); |
} |
} |
catch { } |
} |
private void OnSubChildGridLoaded(object sender, RoutedEventArgs e) |
{ |
try |
{ |
var dataRowView = (DataRowView)((RadGridView)sender).ParentRow.DataContext; |
var ds = dataRowView.DataView.Table.DataSet; |
var childData = dataRowView.CreateChildView(ds.Relations["SubBudgetRelation"]); |
((RadGridView)sender).ItemsSource = childData; |
//סינון הערכים בגריד לפי סוג פעילות |
if (((ComboBoxValues.ComboValues)cmbActivityType.SelectedValue).Id != 0) |
{ |
childData.RowFilter="ActivityTypeID=" + ((ComboBoxValues.ComboValues)cmbActivityType.SelectedValue).Id; |
((RadGridView)sender).ItemsSource = childData; |
} |
else |
{ |
((RadGridView)sender).ItemsSource = null; |
((RadGridView)sender).ItemsSource = childData; |
} |
//סינון הערכים בתיבת הבחירה של סוג פעילות |
if (Convert.ToInt32(dataRowView.Row.ItemArray[5]) == 1) |
{ |
((GridViewComboBoxColumn)((RadGridView)sender).Columns["ActivityTypeID"]).ItemsSource = ComboBoxValues.GetComboValues(dtActivityType.Select("ID < 2000")); |
} |
if (Convert.ToInt32(dataRowView.Row.ItemArray[5]) == 2) |
{ |
((GridViewComboBoxColumn)((RadGridView)sender).Columns["ActivityTypeID"]).ItemsSource = ComboBoxValues.GetComboValues(dtActivityType.Select("ID > 2000")); |
} |
} |
catch { } |
} |
public partial class Window1 : Window { Entities entities; PARENT parent; bool saved = false; public Window1() { InitializeComponent(); entities = new Entities(); parent = PARENT.CreatePARENT(Guid.NewGuid().ToString(), "00000"); gridViewChild.ItemsSource = parent.Child; } private void buttonOk_Click(object sender, RoutedEventArgs e) { entities.SaveChanges(); } private void buttonCancel_Click(object sender, RoutedEventArgs e) { } private void tabItemParent_LostFocus(object sender, RoutedEventArgs e) { if (!saved) { // Create the parent parent.FIRST_NAME = this.textBoxFirstName.Text; parent.LAST_NAME = this.textBoxLastName.Text; parent.MIDDLE_NAME = this.textBoxMiddleName.Text; parent.ZIP = this.textBoxZipCode.Text; entities.AddToPARENT(parent); saved = true; } } private void gridViewChild_AddingNewDataItem(object sender, Telerik.Windows.Controls.GridView.GridViewAddingNewEventArgs e) { // Entity Framework supports identity (server side generated) keys but we // must provide a default key value first. CHILD child = CHILD.CreateCHILD(0, "Test"); parent.ChildProfile.Add(child); e.NewObject = child; } } |