WPF

arkiboys wrote:

on the client side, to use threading, I can use background worker

public DataSet GetDataSet()
 {
 string queryCatStr = @"SELECT * FROM [Category]";
 string queryProdStr = @"SELECT * FROM [Products]";

 DataSet ds = new DataSet();

 SQLConnection dbConn = new SQLConnection("conn_str"))
 dbConn.Open(); 
 SQLCommand cmd = new SQLCommand(dbConn);

 cmd.CommandText = queryCatStr;
 SQLDataAdapter da = new SQLDataAdapter(cmd);
 da.Fill(ds, "Categories");

 cmd.CommandText = queryProdStr;
 da.Fill(ds, "Products");

 DataRelation drCat2Prod = new DataRelation("Cat2Prod", ds.Tables["categories"].Columns["CategoryID"], ds.Tables["Products"].Columns["CategoryID"]);
 ds.Relations.Add(drCat2Prod);
 
 return ds;
 }


 private void Window_Loaded(object sender, RoutedEventArgs e)
 {
 ds = GetDataSet();
 this.DataContext = ds.Tables["Category"];
 this.treeCategories.DisplayMemberPath = "CategoryName";
 }

<TreeView x:Name="treeCategories" ItemsSource="{Binding}" />
...

<ListView x:Name="lstProducts" IsSynchronizedWithCurrentItem="True" ItemsSource="{Binding Cat2Prod}" />

public static void NavigateTo(string sViewName)
{
	//Get the content frame from the main page via the application
	Frame oFR = (Application.Current.RootVisual as FrameworkElement).FindName("MainContent") as Frame;
	NavigateTo(oFR,sViewName);
}

public static void NavigateTo(Frame oFR, string sViewName)
{	
	if(!sViewName.StartsWith("/"))
	{sViewName = string.Format("/{0}",sViewName);}
		oFR.Navigate(new Uri(sViewName, UriKind.Relative));
}

gUI.NavigateTo(sURL);