Thursday, Feb 09, 2012
Login

Category: Programming

SMO SQL Server Error Reading Stored Procedures Collection

The following error is appearing while running Visual Studio 2005 and developing an application with SMO capabilities. It appears when trying perform a foreach( on ActiveDB.StoredProcedures). Could not load file or assembly ‘Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91′ or one of its dependencies. An attempt was made to load a program with an incorrect format. I found [...]


.NET DataGridView Edit Pencil Icon

There’s a problem when editing the DataGridView. Problem: The pencil glyph icon in edit mode wouldn’t go away. Here’s the situation and the solution. Solution: If the property Virtual is set to false the glyph will go away, period. Even after doing this, a call to the EndEdit() function wasn’t required to make the glyph [...]


Visual Studio DataGridView

An application I wrote to compare values in the rows of two datagridviews, set side-by-side, will hide rows if no difference is found; which then leaves just the rows that are different. Simple enough, but an error was thrown when one of the grid’s cells was active. This is the error. Row associated with the [...]


.NET and MySQL

Searching for a document that helps to connect a .NET web application with MySQL is hard to find. So, I thought I would provide instructions I put together while developing my own applications. The .NET infrastructure is very flexible and is easier to use than people think. Here are the steps that I went through [...]


C# Console Application Versions

Well, something stumped me. But figured it out … As part of my C# console application, I wanted to print out the version (Major.Minor.Revision) as part of the help output so I could know the release details. And without the Application object, I just wanted the simple information from the build assembly.