relevant code:
private void themeSelector2_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
if (myDataSet.Tables["Asks"]!=null)
myDataSet.Tables["Asks"].Clear();
DataRowView dw = (DataRowView)themeSelector2.SelectedValue;
string t = dw["Theme"].ToString();
if (t != null)
{
adapter.SelectCommand = adapterCommands.GetAsks(t);
adapter.Fill(myDataSet, "Asks");
AskDataGrid.DataContext = myDataSet;
}
}
catch
{
}
}
// the Combobox (themeSelector) i use for select theme
private void AskDataGrid_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
{
MessageBox.Show("Event");
try
{
if (myDataSet.Tables["Answers"] != null)
myDataSet.Tables["Answers"].Clear();
int i = AskDataGrid.SelectedIndex;
DataRow dr = myDataSet.Tables["Asks"].Rows[i];
string s = dr[0].ToString();
adapter.SelectCommand = adapterCommands.GetAnswers(s);
adapter.Fill(myDataSet, "Answers");
AnswersDataGrid.DataContext = myDataSet;
}
catch
{
}
}