Tech Talk – Page 9 – A software developer on all things tech, and then some

May 5, 2011

Create an Image or Bitmap Image from a Byte[], and a Byte[] from an image.

Have a filestream set up and need to produce an Image or Bitmap image from the blob? No worries, there are a few ways in doing this. First off, let me show you how to create the image or bitmap image from the byte array. To an image specifically. To a bitmap specifically. Both. Now you are wondering how to...

C# Comments: 0

May 5, 2011

Open Documents and Media in WPF’s Web Browser Control in C#

Ever need to display a word document in the same application and didn’t want to shell execute word? Ever need to display text from a rich text file or regular text file? How about quickly displaying an image file? All of these could use there own controls in WPF (Document Viewer, Image control, etc..), however if you use the web browser...

C#/Development/WPF Comments: 6

April 27, 2011

Use Google Chrome To Audit Your Website

Ever need a quick way to audit your website to check for errors, but don’t want to start? There are plenty of options out there to do audit of your website. but I’m going to focus on an easy and quick option for you today. Step 1: Download Google Chrome. http://www.google.com/chrome/intl/en/landing_chrome.html?hl=en Step 2: Navigate to your website you would like to...

Development Comments: 0

March 29, 2011

Object Cannot Be Cast From DBNull To Other Types : Resolved

A quick post for you guys. I’m currently debugging a windows form application and came across “Object Cannot Be Cast From DBNull To Other Types”. Basically what this translates to is that you have to check for the DBNull before converting. For example : You would just need to add

C#/Development Comments: 0

March 23, 2011

Fixing A Blue Filled Checkbox in .Net

If you ever seen the above check mark, you are probably wondering what the heck is going on. First off it’s not checked or checked, some in between state where it’s just filled with a blue square. Second off you even, most likely, have a variable bound to it, and yet it still displays as this! The issue is that the...

C#/SQL Comments: 0

March 15, 2011

Drop, Truncate, and Delete : The Difference

If you wanted to get rid of all the data in a table, then you could you either of the three. However there are certain situations which using a different one of these is the best route to go.

SQL Comments: 0

March 14, 2011

Create a Filestream In SQL Server 2008 In Three Easy Steps

Step 1 : Enable FileStream The first step is to enable the filestream capabilities on your SQL Server instance. This can be found by going to your server properties in your SQL Server Configuration Manager and enabling the filestream there. Microsft explains how here. Step 2 : Creating a FileStream Database The following script will create a filestream database for...

SQL Comments: 0

March 11, 2011

Do a Like Statement in LINQ in C#

There has been a few times I needed to do a like statement in LINQ, but didn’t know exactly how to go about it. Just in case there are you out there looking for the same, I thought I would post what I did. For example, say you had this SQL statement : This would translate to LINQ code in...

C#/SQL/WPF Comments: 0

March 11, 2011

Blog Migration

Hey guys, I moved some stuff around and now the pictures, links, and some of the text is broken. Be patient, I’m going to fix over the next few weeks.

Uncategorized Comments: 0

February 2, 2011

Quick Newbie SQL Tips

I go back and forth with different versions of SQL which at times will require different syntax. I started using primarily SQL Server 2008 R2 so I needed an update on some certain functions. To help me remember and to save you some time, here they are. Adding Multiple Colums There has been a few times where I needed to...

SQL Comments: 0

January 19, 2011

Building The Perfect SQL Script. Part 1 of N

Introduction Im going to start off by saying I am by no means an expert in SQL. I am however on the road to increase my skills and work towards more efficient and cleaner SQL code. With that said, Im going to start an on going series of posts which I will post from time to time which include tips...

SQL Comments: 0

January 12, 2011

Replacing Names Quickly in Visual ‘s Find and Replace

Part of the perks of moving your application to MvvM, you dont have to name your controls since you are binding everything. This frees up resources when running your application. Since my application was fairly large, I decided to dabble in Visual ‘s regular expression to replace all the names. I ended up putting :

WPF Comments: 0