Create your own media browser: Display your pictures, music, movies in a XAML tooltip

In my prior post, I showed how to use XAML and XAMLReader to create inline XAML to display the results of a query.   Today, let’s take it a step further: let’s create a query of all the media (pictures, movies, music) in your “My Documents” folder and display the names and sizes in a…

6

Use the DispatcherTimer, Popup and even a movie to enhance your data presentation

We can subclass the prior Windows Presentation Foundation (WPF) class called Browse that displays the results of a query. This subclass will add a WPF Popup to it.   The popup can easily be added to either a ListView or the ListBox sample I posted earlier (Use LINQ with WPF : Styles and DataTemplates in…

4

Use DataTemplates and WPF in code to create a general purpose LINQ Query results display

In my last post, Use LINQ with WPF : Styles and DataTemplates in code, I showed how to use DataTemplates in code to show the results of a query in a ListBox.   Let’s make a reusable class called Browse which creates WPF content as a ListView from a LINQ query and generates columns and…

4

Use LINQ with WPF : Styles and DataTemplates in code

Using Windows Presentation Foundation (WPF) and LINQ is easy in code. We’ll create a query and display it in a WPF ListBox   Using XAML is harder: the ObjectDataProvider class works with non-anonymous types.   Start Visual Studio 2008 (or 2005 with Visual Studio 2005 extensions for .NET Framework 3.0. Linq is only in 2008)…

12

Use new XML Features of VB to generate dynamic scripts and text files

There’s a very useful feature that FoxPro users have had for over 2 decades: being able to output text in any format, with WYSIWYG and the ability to embed expressions (The TEXT…ENDTEXT command)   Generating XML, HTML, Bat files, PowerShell Script, etc is a breeze with this command. Free form text between the “TEXT” and…

13

Querying Northwind with Group By bug fixed

In this post: http://blogs.msdn.com/calvin_hsia/archive/2007/08/17/install-northwind-for-sql-express-and-use-visual-studio-and-dlinq-to-query-it.aspx   I mentioned how a bug with Group By and composite keys made more local calculations. Using the AsEnumerable operator caused the query to execute locally.   I now have a build of Visual Studio that has the bug fixed and I modified the query to remove the AsEnumerable().   The…

1

Use Stored Procedures when you can for efficiency

In this post (Install Northwind for SQL Express and use Visual Studio and DLINQ to query it ) I posted a fairly complex SQL command. Of course, it’s important to keep in mind that a more efficient way of executing this query may be by keeping all the data on the server (which might be…

2

Install Northwind for SQL Express and use Visual Studio and DLINQ to query it

SQLExpress is free and comes with Visual Studio, but the sample Northwind database isn’t included.   You can download sample databases Northwind and Pubs from http://www.microsoft.com/downloads/details.aspx?FamilyID=06616212-0356-46a0-8da2-eebc53a68034&displaylang=en.  (or you can use the Fox Upsizing wizard to send the fox native Northwind to SQL Express or SQL Server)   To install Northwind or migrate any other MSDE…

6