C# Solutions .NET

Silverlight WCF Proxy Close

2010-01-04T09:42:00.000-08:00

Hi, I just wanted to let you all know that I believe it is advantageous to close your proxies when leaving a silverlight page. The best way, I believe, is to do this in the class destructor.

~MainPage()
{
if (proxy != null)
{
proxy.CloseAsync();
proxy = null;
}
}

Hope this helps someone.

How to Access an Access Database from GoDaddy

2009-12-14T12:40:00.000-08:00

Here's a way I found useful for accessing an access database in code from GoDaddy, Hope it helps someone.

First Include:
System.Web

private static string GetConnectionString()
{
HttpContext serverContext = System.Web.HttpContext.Current;

string db_path = string.Empty;
string db_dir = serverContext.Server.MapPath("access_db") + "\\";
db_path = db_dir + "Crossroads.mdb";
string connectstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + db_path;
return connectstr;
}

Microsoft's bizspark program

2008-12-28T15:58:00.000-08:00

I decided to try and use the program by Microsoft called Bizspark http://www.microsoftstartupzone.com/. It's basically a way for you to get your name out there with your business idea. It's also an incentive to get your idea off the ground. Some of the great benefits you get by signing up are free access to Microsoft Development tools and free webspace to try out your asp.net ideas. There are some strings attached to signing up though:

1. You must pay Microsoft a $100 fee after three years.
2. You must not have had an operating business with your idea (startups only).
3. You must be in the business of developing software.
4. You must be private
5. You must have < 1M in annual revenue (not a problem in my case)

Also, you have to find a sponsor before you can enroll. If you are interested in enrolling you will be presented with a list of available businesses on the enrollment page willing to help sponsor along with their contact email address.

Check it out and Good Luck!

Writing a thread-safe console log

2008-11-07T11:32:00.000-08:00

A few days ago, I ran into the problem of how to display logging or status info in the user interface when the log messages are generated in a different thread. I found a result that seems to work satisfactorily at the moment.

I'm going to give the example in VB .NET but it will work easily in C# also.

First off, create a simple delegate:
Public Delegate Sub LogSafeCall(ByVal s As String)

Then create a Sub to provide thread safety. I will use a listbox in this example but you could also use a textbox. The reason for choosing the listbox is due to the fact that it stores strings in a collection. A textbox would require appending to the text property, and...since strings are immutable, this would create many seperate strings in memory.

Here's the Threadsafe logging function, m_console is a listbox control:
Private Sub Log(ByVal s As String)
If (m_console.InvokeRequired) Then
Dim d As LogSafeCall = New LogSafeCall(AddressOf Log)
m_console.Invoke(d, s)
Else
m_console.Items.Add(s)
'if you wish to have the last item selected then uncomment the following:
'm_console.SelectedIndex = m_console.Items.Count - 1
End If
End Sub

Since I wanted to Log in a file as well as display the messages into the textbox, I created the following class and inherited the TextWriter streaming class So here is the complete code:

Option Explicit On
Option Strict On
Imports System.IO
Imports System.Windows.Forms

Public Delegate Sub LogSafeCall(ByVal s As String)
Public Class ListBoxWriter
Inherits TextWriter
Private m_console As ListBox
Public Sub New(ByVal console As ListBox)
m_console = console
End Sub
Public Overrides ReadOnly Property Encoding() As System.Text.Encoding
Get
Return System.Text.Encoding.ASCII
End Get
End Property

Public Overrides Sub WriteLine(ByVal value As String)
MyBase.WriteLine(value)
Log(value)
End Sub

Private Sub Log(ByVal s As String)
If (m_console.InvokeRequired) Then
Dim d As LogSafeCall = New LogSafeCall(AddressOf Log)
m_console.Invoke(d, s)
Else
m_console.Items.Add(s)
'm_console.SelectedIndex = m_console.Items.Count - 1
End If
End Sub
End Class

New Dell Laptop XPS M1730

2008-10-30T08:50:00.000-07:00

Last week, I bought a Dell Laptop for my road clients. It's an XPS Model 1730 with a whopping 17" screen. I always buy my Dell stuff in the outlet store and this laptop was refurbished. It boasts a dual core 2.8 Ghz Intel CPU, 4 GB Memory and came with Vista Ultimate. I paid around $2k for the system. So far I like it very much, the bootup is very fast and all of my development software installed very nicely. It has one of those fancy new 128 MB solid state drives that the operating system resides on and I guess that's why bootup is so fast. I also have a 360GB standard Seagate drive that I purchased at tiger direct for around $80. I like the screen size very much. This is NOT a good laptop for portability since it weighs a lot and requires a mammoth sized power supply that is about 8 x 4 x 2 inches. It's great for me because I frequently need the power of a desktop without lugging a desktop around in my car. If you are working on a plane or while riding the bus, this probably would not be a good choice. The power drain on the batteries is about 1 hour, perhaps one could get it to two hours by adjusting the power settings. If you require a more portable model, the XPS 15" models are just about the same as this 17" model in power and features, but much more portable and the batteries last longer. My son, Erik, uses a Dell XPS 15 while in college and likes it very much.

CodeSmith Review

2008-10-16T06:42:00.000-07:00

Most of my coding happens to be repetitive. Therefore I'm always thinking there's got a be a way to generate the similar code and rename the classes and various attributes. While I was on David Hayden's site http://www.davidhayden.com/, I saw an ad for Codesmith. After reviewing the features and asking a few folks in the IT world what they thought about it, I decided to give it a try. Instantly I fell in love with it because of it's ease of use and I was instantly productive straight out of the box! Here's some things I was able to do:
Generate Code based on database schema - using included examples
Port my own code into a template for re-use
Generate both VB and C# Code

The possibilities are endless, you can create libraries of code you are confident works and you wish to reuse over and over. There's a handy properties pane similar to the one in Visual Studio that you can use to change the custom properties you define in the template file. Once the template file is written, all that's required is setting a few properties in the properties pane and generating the code.

There's a few videos to help you get started on the Codesmith website http://www.codesmithtools.com/ . I highly recommend the product if you find yourself writing similar code all day. Hey, you can do a days work in 5 minutes once the template is in place! Look good all day while hardly breaking a sweat. It is a bit pricey for those, like me that are buying this themselves for around $400, but worth it in time savings.

Seagate 1.5 TB Drive

2008-10-15T19:38:00.000-07:00

Yesterday, I received a new Seagate Barracuda 7200.11 1.5TB Hard Drive ST31500341AS - Serial ATA 7200/32MB/SATA-3G. I run a Vista Machine with Dual AMD 3GHZ Processors and ran into problems when creating the partition for this drive. It takes a long time to format/partition the drive, I guess, due to it's size. When the format reached format: 73%, it just hung there all night. I googled on this and found one other person had this problem and it was resolved by enabling the second SATA controller. I don't have a second SATA controller so I ended up formatting it on another machine via a SATA drive enclosure using USB 2. Not quite the resolution I was looking for, but it worked ok. I still would hate to do this again but it worked. I guess sometimes it's whatever works. Why do I have such a large drive you ask? Well, I do a lot of data intensive programming and my 500GB drive is 2/3 full allready!

SQLCE and ASP.NET

2008-10-11T07:15:00.000-07:00

Sometimes it's difficult to decide which database to use for a particular application. I found myself in this dilemma when creating my website. Most of my website is not really data centric so I was thinking maybe using MySql since it's free, or perhaps Sql Server since I already have it installed on this machine. I decided to go with Sql Compact 3.5 since it's new and I wanted to see what was involved with getting it to work with LinQ. The first problem I ran into was creating the SQL Enitity classes with the Compact Edition. It's easy to create the entities with SQL Server 2008, which involves just going to the project and adding a LINQ to SQL Classes Template to your project and dragging over the tables, or whatever you need for you entity class. However, with SQL Compact, this doesn't work. You could create the entity class by hand, but that involves a lot of typing (no pun intended).

Here's how I solved the problem:

There's a command line tool in the Microsoft SDKs folder for creating entities for various databases called SQLMetal. It's in the folder: \Program Files\Microsoft SDKs\Windows\v6.0A\Bin\SqlMetal.exe

The use of the program is as follows:

SqlMetal.exe MyData.sdf /code:MyCode.cs

example: SqlMetal.exe northwind.sdf /code:northwind.cs

That solved the problem and created the Sql Compact 3.5 entity.

I created a batch file to make it easier (see below) :

@echo off
Set SQLMetalPath="C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bin"
Set DBPath="C:\Users\Jonathan\Documents\Visual Studio 2008\WebSites\CSharpSolutions_8_2008\App_Data"
Set AppCodePath="C:\Users\Jonathan\Documents\Visual Studio 2008\WebSites\CSharpSolutions_8_2008\App_Code"

cd %DBPath%%SQLMetalPath%\SqlMetal.exe CSharpSol.sdf /code:%AppCodePath%\CSharpSol.cs

Here's problem #2 I had using SQL Compact 3.5 but the resolution came from Steve's site:

Force SQLCE to run under ASP.NET
Steve Lasker posted blog entry on how to use SQLCE under ASP.NET using the pre-release version of the SQLEV. Under SQLEV you set a flag that would tell the SQL Connection, “yes I know this isn’t supported, but let me do it anyway”:
AppDomain.CurrentDomain.SetData("SQLServerEverywhereUnderWebHosting", true)
As you can see the name of the product is right there in the key. Well they changed the name of the product and so they changed the name of the key. So, if you were using the beta for development and are now switching over to the release version of SQLCE , you will need to change the key:
AppDomain.CurrentDomain.SetData("SQLServerCompactEditionUnderWebHosting", true)
That should allow you to use the database under ASP.NET. Now you can revel in the fact that you are swimming in unsupported waters!

Note:
I placed the AppDomain.CurrentDomain.SetData("SQLServerCompactEditionUnderWebHosting", true) line of code in my default page's constructor in the code behind section:
Hope that helps

My Thoughts on the Financial Crisis

2008-09-25T20:47:00.000-07:00

This is a bit off topic from the computing subject, but we are living in a remarkable time in history right now. The financial markets are about to crash probably next week. Washington Mutual just folded today and I'm certain more will follow soon. In a way, I feel that these companies deserve to fail because they were imprudent and lacked integrity. My reaction at this point is to let the market do what it does for the next few weeks before any government intervention is introduced. I know that it will hurt business since the money supply will be tight for the foreseeable future, but that's the cost of these times. The markets will eventually work themselves out without intervention from the Bush Administration, although it may be quite painful. I don't believe the role of government should be insurance for failing banks. Perhaps at the end of this mess, common sense and integrity will return to the business of banking. Well, I'm not much of a banker, and perhaps I'm all wet, but that's the way I see it.

First Blog Ever!!

2008-09-24T08:05:00.000-07:00

Hello everyone: This is my first ever blog, hard to believe since I work in the technology field. I guess I've just been too busy writing code. Well, now that the market has slowed some, I have time to write a blog! At the risk of sounding like a dating summary, here's some information about me.

I live in Milwaukee, WI and work in the IT line of work as a C# or VB developer. Most of my days are spent at home writing code for my clients. I enjoy writing code and helping others solve a particular problem with their computer.

My hobbies include reading, playing the violin, bicycle riding, working on the house and sometimes, very rarely, due to money, I pilot small aircraft such as a Cessna 172.

I have a strong faith and honesty and integrity are important to me. I strive to give my clients good value and provide straight answers to their questions.

I read a lot of books just to keep up in this crazy work environment. One of the books I'm going through now is called asp.net unleashed 3.5 and it's a massive book that weighs a lot. When I'm through, I plan to use it as a boat anchor, since by the time I finish it, something new will have arrived. I find when I'm reading it's not enough to just read, so I started my own website http://www.csharpsolutions.net. I can run through the examples in the book on a real working environment. It's much easier to retain knowledge in my humble opinion, when you actually write the code and play around with it. The website is hosted at home in my garage and is on a Vista based PC, (Dual Core AMD processors 3500+ for you techies).

All of my website code is written using Microsoft ASP .NET version 3.5 framework and Visual Studio 2008. Visual Studio and the .NET framwork has made leaps in usability and functionality and is much more feature rich than previous versions. Previously, most of my html scripting was done with Dreamweaver and then the coding done in Visual Studio. Now that VS2008 has html scripting and smart code features, I prefer to use only VS2008. I firmly believe there is no other comparable development environment out there for writing business applications.

To host my site at home, I use a third party name hosting service called ZoneEdit to redirect my assigned Time Warner IP Address to the URL. It's very handy to host the site at home, but it's probably not a good solution for business app hosting since Time Warner limits the upload bandwidth.

Well, thanks for reading my blog. I plan to write reviews on books I've read as well as submitting code examples and techniques I use to solve a particular problem.