Archive for May, 2011

Creating a simple Doodle (drawing) like application using Silverlight and Reactive Framework (Rx)

May 26, 2011 3 comments

I am looking forward to speaking to the Charlotte ALT.NET User Group next Thursday (6/9/2011). Here is a summary of what we are going to cover:

The Reactive Framework (Rx) is pretty exciting and has a lot of promise.
Sometimes the hardest thing with new technology is not understanding but seeing where
you can put it to good use. Come out and take a look as we build a simple Doodle
application and leverage the power of Rx as we go.

Hope to see you there…

Building a Windows Phone 7 App using JSON/ASP.NET MVC Data Service Layer

May 25, 2011 8 comments

I had a great time speaking at Charlotte’s Enterprise Developers Guild last night. Here is a link to my slides and sample code.

Thanks again to everyone who came out!

Building a Windows Phone 7 App using JSON/ASP.NET MVC Data Service Layer

May 23, 2011 4 comments

I am going to be presenting this Tuesday at the Developers Guild in Charlotte. We will take a look at leveraging ASP.NET MVC and JSON to become your best friend from the point of data serialization. Want to build a simple WP7 application? Want a simple way to pass data back and forth from the server? JSON seems to be the obvious choice when developing web applications, how does it work when developing WP7 applications?

Hope to see you there…

Carolina Code Camp 2011

May 15, 2011 1 comment

I had a great time speaking at the Carolina Code Camp 2011. We had an awesome turnout. Thanks to all who helped make it a success. I look forward to the next one!

As promised, here are the slides from the presentations I made:

Silverlight Dashboards

Taking a look at Caliburn.Micro

Taking a look at Prism 4.0

Thanks again for coming out….

I am speaking at Carolina CodeCamp 2011

I am going to be doing three presentations at the Carolina CodeCamp 2011. The three topics include Silverlight Dashboards, Taking a look at Caliburn.Micro, and Taking a look at Prism 4.

Hope to see you all there.

Simple Tabular Report Generation in WPF

May 11, 2011 4 comments

This post is on using the power of the ReportViewer in WPF to build simple tabular reports on the fly. I did a presentation on this a while back and I noticed that there is some interest in building reports and having the ability to query your database on the fly without the need for SQL Server Management Studio or MS Access.

The sample included in this post is a simple mock up that can grow with time. It gives you the ability to connect to any SQL Server backend. You can then write your SQL in the editor. Finally, you can preview your data, make any changes you want to ensure that it is ready for a generating a report. You then click on the Generate Report button and the Preview Report tab becomes selected rendering a dynamic report based on your query. With very little code, you get a simple query editor, code generator, and local report viewer.

In this first post we will just take a look at the user interface but in a following post, we will cover the code necessary to get this working.

My example is using the AdventureWorks database but you can use whatever database you like. When the application first starts, are presented with the following window:

Click on the button as indicated in the following screen shot:

Setting up the Connection

Follow the dialog and enter in your information for creating a connection.

Dialog for creating a database connection.

You can test your connection and verify that it is correct.

Dialog for testing the connection.

Click the Connect button to create the connection. Type in the query you wish to perform:

Write in your SQL query.

You can now either execute the query or parse it. The following is a screen shot of the query executed:

Query and metadata results displayed.

As you can see, we get our results but we also get a grid in the middle that provides us with a bit of metadata for formatting our report. You can also provide a title for the report.

Metadata set for report generation.

Then by clicking the Generate Report button, we see the following:

Report rendered in the ReportViewer control.

By now you can see that it is very easy to create some dynamic reports in very little time. In the next post we will go over the code and architecture required to get this to work. I have included the slides, source code, and a walk-through from my presentation.

Hope this helps….