tags:

views:

37

answers:

0

Hi,

I am beginner to WPF. I create the menu from database tables using following code.... Now i have struck in how to call corresponding windows when clicking menu items? Please its urgent one... help

private void Window_Loaded(object sender, RoutedEventArgs e) { mymenu.DataContext = getmenu(); }

private DataSet getmenu()
{
  SqlConnection NwindCon = new SqlConnection("server=(local);uid=sa;pwd=zillion;database=ecdslabc20102011");
  SqlDataAdapter navigate = new SqlDataAdapter("select * from navigate order by code ", NwindCon);
  String lc_query = "select n1.code,m.menu_name,m.program from navmenu n1 inner join menu m on n1.menu_code= m.menu_code order by code";
  SqlDataAdapter navmenu = new SqlDataAdapter(lc_query, NwindCon);
  DataSet menudata = new DataSet();
  navigate.Fill(menudata, "dtnavigate");
  navmenu.Fill(menudata, "dtnavmenu");
  DataRelation menurel = new DataRelation("ChildRelationship", menudata.Tables["dtnavigate"].Columns["code"],
     menudata.Tables["dtnavmenu"].Columns["code"], true);
  menurel.Nested = true;
  menudata.Relations.Add(menurel);
   return menudata;
}

Thanks in advance.... Please help me...