New C# and the installer tutroial for .Net 4.5 coming soon!

4 03 2014

Since I’ve posted the tutorial on .NET and the installer it has maintained a good following. I believe that this has helped out a lot of you when it comes to personal projects or work questions that you might not have otherwise gotten the answer to without coming here.

Because of this I’m re-writing this tutorial in .NET 4.5 to bring it up to date for those of you struggling to get it work in the newer frameworks. I just wanted to drop a quick note, if you’re having issues getting the current tutorial working just hold up, I’ll have a new one out here soon.

Thanks for the support guys.


XNA Project Update 12-29-2010

29 12 2010

I’ve made a little bit of progress since the last post. I have begun the work on a sky sphere, after doing quite a bit of research on the best way to do things, I’ve decided that no matter the difficulty a gradient sky sphere is going to be the most dynamic for what i would like to do, now i just need to figure it out…

So far i have the sky sphere correctly moving with the camera, now i want to be able to shade this and have it change realistically from day/night and visa-versa. So starting from here, lets see where this will go, wish me luck I’ll need it:

New XNA Project

28 12 2010

Wow, how long has it been since I’ve made a blog post? Seems like its been quite a while, and according to the dashboard i think it has been.

I’ve been working on a new XNA project in my free time lately. The basic idea is to create a terrain rendering system, and a small RPG style game that is fairly sandbox style. It seems as though things are falling into place, things have come pretty easy thus far and i feel like I’ve made good progress. Check out this screenshot:

One Region test

One Region Rendered

This is one successfully rendered region of the terrain, I’m working with one other developer who’s task currently is to generate some sort of neat terrain layouts and come up with those algorithms. I want to keep the project as procedural as possible, with no set “maps”.

We’ll see how it goes and i’ll provide updates as we work. Maybe i’ll even get around to writing some tutorials for you guys as it seems my windows installer tutorial and XNA stuff has taken off pretty good. Stay tuned!

Excel and C# – Easy

19 09 2008

When i was first presented with this problem, I had no idea how i was going to go about doing it, searching the internet for a little while is always my first step. Even when i get to one solution i usually keep researching to see if there is anything better, that way i at least have a few choices before I go coding in the wrong direction.

In any event, the task was to integrate a Windows Form with excel, to import data easily into another application or a database. There are a few problems with the thought of this, “how do i interact with excel” and “how do i deal with different versions?”

First lets deal with the interaction, this may not work for all version but it does with 2007 and 2003, which i can test from my laptop.

Excel is basically like using a SQL database, there are some differences on how to do things, but its easiest I found if you just import to a data table and work with the data from there, rather than trying to work through excel. (Why do that if you could just open excel anyway?) So to get it started were going to use the System.Data.OledDb assembly, make sure to add that in the “using” statements at the top.

Once we have that we want to create a new OleDbConnection:

private OleDbConnection conn;

Then down a little bit more in the constructor we want to check the version of excel they are using, i just do this by simply making a bool and basing it off of the file extension. “.xls” is 2003 and “.xlsx” is 2007, i just check that and set a string for 2007 or 2004. Once we get that out of the way we can make the connection string:

if(excelVer == "2007") {
     conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + file + ";" + "Extended Properties=Excel 12.0;");
else {
     conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + file + ";" +      "Extended Properties=Excel 8.0;");

As you can see above there are two different connection strings for the respective versions of Excel. Based on what file they are using were going to want to change that connection string, so if you allow you user to change the file whenever they want in your application, you need to change this with it!

After that its as simple as SQL. Lets create a OleDbDataAdapter:

OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [" + worksheetName + "$]", conn);

Then we just use da.Fill(dataTable) and we can bind that to a data grid or do whatever with it! Thats it! If you need any help, just leave a comment and i’ll do what i can to get back to you!

ASP.NET 2.0 styles don’t show up in FireFox, fix!

25 08 2008

I was stuck on this problem for the majority of the day today and it was driving my crazy, i figured i would share my particular solution with everyone. Almost every place I looked up for an answer to this question had something to say about how the server is configured wrong, when i reality it had something to do with my master page!

If you cant figure out why your styles just wont show up in Firefox see if this is a fix for you too. Check the master file, make sure that you have your stylesheet linked correctly. If all is well there make sure you do NOT have a content placeholder in your header tags. For some reason if firefox can see that content placeholder in the head it will void the rest of the tags up there except for the title tag.

This just happened to be a fix for me and i hope it can help someone else!

New XNA Goal

12 08 2008

So I’ve been thinking a lot lately about developing a game within the XNA developer studio. I’ve talked with a lot of my friends about it; friends who have also taken XNA classes with me or have been involved in that type of thing. No one seems to really have the time for anything like that at the moment. So I’ve decided to take thing into my own hands, and start a personal XNA project.

With that being said I’m going to start from the beginning, with just the ideas in my head, I’ll begin with all the planning, choosing an idea, writing it out, documents. Then from there I’ll move on to development, and eventually try to get something released.

I think whats important here is ACTUALLY DOING IT. So that’s why I’m going to start small, on hour a day, one time a week. If i get more momentum, then I will increase that. If anyone would like to collaborate with me, please send me an e-mail at: wade -AT- utahairsoft -DOT- com.

New tutorial.

1 07 2008

I know that i havent updated in a while, sorry about that. I’m still alive though so thats a good thing.

I’ve finally graduated from Neumont Uiversity and I’m out into the workforce. It’s good so far, I’m just glad that its not school! Anyway, I’ve posted a new tutorial on the well… tutorials page. It has to do with Application Unlocking your Samsung ACE, which is the phone that I currently have. It was pretty rough finding information on it so hopefully it will help someone out.

Thanks for reading, I’ll try to post more!