I am working on a Windows desktop app that will allow the user to do the following:
1. Select an XML file
2. Select an Element from the XML
3. Display the child elements and the associated values
4. Select a specific value of a child element and display all occurrences of that value
All of this will displayed in a Windows Forms DataGridView Control.
So I have wanted to learn some more Linq for a while so I decided to do use Linq for querying the XML data instead of using XPath.
This post is the first post of what will likely be a few posts in this series as there are some other items I will cover. I will want to have two panels in this application, one that contain the XML structure(so the user can select which Elements they want to view) and the other panel will show the results. I might also have a 3rd panel that shows the source xml. I am going to try and do some drag and drop to allow the user drag values, we'll see how I get on with that (easy in the web world so am hoping it's not too clunky in the winforms world).
Part 1: Display Linq to XML Query Results in Windows Forms DataGridView
Coal Cart Design
My blog about software development on the MSFT .Net platform, life in Co. Leitrim and anything else of relevance.
Friday 18 May 2012
Sunday 6 May 2012
Sliabh Anierin Mountain Walking
It was a lovely day in Drumshanbo, Co. Letirm for short hike up the Sliabh Anierin Mountain. Myself and the boy set out to go an do a little bit of exploring. We headed out the Dowra Road (R207) and took the first turn to the right at the L7305. You come to a crossroads which is marked as the Leitrim Way to the left and right. You don't take the left or the right but instead you go straight through the cross roads. You follow this road and you are driving up the mountain. You keep going up this road until you can't go any further. I met a farmer up there who said that I was more than welcome to park my car at his shed and continue walking up the mountain.
Saturday 5 May 2012
MS SQL Correlated Subqueries
Well you can learn something new every day so I am finished up
for the day and thought I would write about it.
I was writing a report for a customer and they wanted a
count of values in a column. Simple stuff right, you just do a quick:
SELECT column1, COUNT(column3) FROM table1 GROUP BY column1
You end up with something like:
Value1 100
Value2 50
Value3 75
Value2 50
Value3 75
The problem here is what to do when you want to count the
occurrences of the unique values in the column and have these counts output as
individual columns in your report. Let’s say you have a data import job and the
status of the each row you import is either going to be Pending, Completed or
Failed.
Thursday 26 April 2012
Microsoft Reactive Extensions Rx Observer Pattern Kata
Overview
NOTE: So this is not a discussion about Reactive Extensions by Microsoft in relation to what they are and why they should be used. This has already been coverved extensively on Microsoft's website HERE.
The point of this post is to provide details of a Kata that can be practiced. The design pattern implemented here is the Observer pattern. Instead of implementing this pattern using Events, I am implementing this using Observables.
Tuesday 3 April 2012
Observer Pattern and MSFT Reactive Extensions
So I was practicing my observer pattern programming kata and came across the MSFT Reactive Extensions. I am going to put up a post this week with a new kata that implements observer pattern using the Reactive Extension (Rx) --> http://msdn.microsoft.com/en-us/data/gg577609
Susbribe to this blog now to be notified when this kata is available.
Susbribe to this blog now to be notified when this kata is available.
Friday 23 March 2012
Display Flickr photos on .Net MVC web page
Functional Brief
I am working on a website for the Drumshanbo An Tostal Festival and one of the requirements was to show photos on the web site that the festival committee has stored on Flickr. I didn't want to just copy and paste a bunch of HTML onto the web page. I found that the existing web site they had was slow to load all of the Flickr images. What I really wanted to do was show a few photos and then provide a link to the full library of photos on Flickr.
Flickr allows you to add a set of photos as a PhotoSet. I wanted to get the last 5 PhotoSets from Flickr and display 7 photos from each set on the web page. The reason why I wanted 5 PhotoSets and 7 photos as that amount of photos fit in well with the size of the page space I wanted to fill.
I am working on a website for the Drumshanbo An Tostal Festival and one of the requirements was to show photos on the web site that the festival committee has stored on Flickr. I didn't want to just copy and paste a bunch of HTML onto the web page. I found that the existing web site they had was slow to load all of the Flickr images. What I really wanted to do was show a few photos and then provide a link to the full library of photos on Flickr.
Flickr allows you to add a set of photos as a PhotoSet. I wanted to get the last 5 PhotoSets from Flickr and display 7 photos from each set on the web page. The reason why I wanted 5 PhotoSets and 7 photos as that amount of photos fit in well with the size of the page space I wanted to fill.
Thursday 22 March 2012
C# Ternary Operator
Well I read about ternary operators the other day and wondered when I was going to get to use them.
The c# ternary operators replace the need for the if else statement. It's doing the same thing but it's certainly less typing involved and more condensed to look at.
Subscribe to:
Posts (Atom)