WinRT XAML工具包TreeView保存状态(WinRT XAML Toolkit TreeView Save state)
有一种方法可以保存树视图的状态(扩展和选定的属性),以便在导航和应用程序的墓碑中保持状态?
我不想在itemsource上添加这样的信息,因为语义上是两个不同的metter。 ItemSource是与扩展状态没有任何关系的域对象。
谢谢。
there is a way to save the state of a treeview (expanded and selected properties) in order to keep state during navigation and tombstone of application?
I don't want to add such of information on itemsource since semantically are two different metter. ItemSource is a domain object not having any relationship with expanded state.
Thank you.
原文:https://stackoverflow.com/questions/36503784
更新时间:2022-06-27 12:06
最满意答案
嗯,这满足了简要;-):
SELECT a.* FROM table_a a JOIN (SELECT * FROM table_b) b ON b.id = a.id ORDER BY mark DESC LIMIT 1;
Well, this satisfies the brief ;-):
SELECT a.* FROM table_a a JOIN (SELECT * FROM table_b) b ON b.id = a.id ORDER BY mark DESC LIMIT 1;
相关问答
更多-
连接将表现更好(几乎所有情况下),但子查询更容易理解和编写,特别是对于SQL较新的人。 对于小型数据集,您可能看不到任何差异,但随着您的设置上升,它将变为指数级。 加入与子查询 Joins will perform better (for almost all cases) but sub queries are easier to understand and write, especially for people who are newer at SQL. For small data sets yo ...
-
嗯,这满足了简要;-): SELECT a.* FROM table_a a JOIN (SELECT * FROM table_b) b ON b.id = a.id ORDER BY mark DESC LIMIT 1; Well, this satisfies the brief ;-): SELECT a.* FROM table_a a JOIN (SELECT * FROM table_b) b ON b.id = a.id ...
-
你真的很亲密,你甚至不需要工会。 这里有三种使用case语句的方法,一种使用NVL(),一种使用内联视图(如果限制更改表结构,我会使用内联视图,它'应该'预先形成最好的。但是,如果要获取的用户列表足够大,您可能希望在内联视图的每个select语句中添加where子句的附加副本。 SELECT `user_id` as UserId , (CASE WHEN `user_type` = 'S' THEN `stu_first_name` WHEN `user_type` = 'E' THEN `emp_fi ...
-
希望这两个表不仅仅是数据集,但如果它们可能是来自sql的真实数据库表,我的建议是你可以通过SQL查询轻松地操作链表的数据。 PS - 导入以下参考。 Imports System.Data.SqlClient Private strConn As String Private sqlConn As New SqlConnection Private sqlcmd As New SqlCommand Private Sub getdatatable() strConn = "Dat ...
-
一个选项使用ROW_NUMBER : SELECT emp_id, full_name, place, from_date FROM ( SELECT pe.emp_id, pe.full_name, po.place, po.from_date, ROW_NUMBER() OVER (PARTITION BY pe.emp_id ORDER BY po.from_date DESC) rn FROM personal_details pe INNER JOIN po ...
-
您正在寻找LEFT JOIN : select t1.*, t2.status from table1 t1 left join table2 t2 on t1.customer = t2.customer; You are looking for LEFT JOIN: select t1.*, t2.status from table1 t1 left join table2 t2 on t1.customer = t2.customer;
-
Select p.*,s.*(for all columns) from project p, Student s inner join p.id=s.id Select p.*,s.*(for all columns) from project p, Student s inner join p.id=s.id
-
没有一个单独的api调用来获取数据集中所有表的模式详细信息。 您需要执行tables.list以获取数据集中表的ID,然后在每个表上使用tables.get来获取其模式。 There is no one single api call to get the schema detail of all of the tables in a dataset. You would need to do a tables.list to get the ids of the tables in a dataset, ...
-
您应该使用内部联接来获取所需的结果,而不是此处的Distinct关键字。 尝试这个 SELECT b.BRANCHID, b.BRANCHSUBURB, m.MOVIENAME, sc.SCREENCAPACITY, se.SESSIONDATE FROM SESSIONS se INNER JOIN SCREEN sc on se.SCREENID = sc.SCREENID INNER JOIN BRANCH b ON b.BRANCHID = se.BRNACHID INNER JOIN MOVIE ...
-
嵌套查询以查找表B中的详细信息,以获得表A中的最大值(Nested query to find details in table B for maximum value in table A)[2022-06-23]
以下查询如何执行? 它的工作原理是首先找到所访问的机场中最北端的Y坐标。 然后执行相同的查询,该查询由先前查询中的Y坐标过滤。 最后一步是找到机场。 drop table airports; drop table flights; create table airports( apid int not null ,apname varchar(50) not null ,x int not null ,y int ...