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...