Skip to content

MikeBevers.be

Putting it out there…

Archive

Archive for June, 2009

More than a few clicks…

It’s common that you create a database on your local development machine. Afterwards, you move the database to a production server.

Well, I thought you could just backup the database with the SQL Management Studio from one machine and restore it to another. The Backup/Restore process wasn’t the problem. When I tried to logon with the associated User/Password account, that I created on both machines and which was owner of the development database, I didn’t have any permissions to my database.

continue reading…

Region code snippet

To organize my code, I use a lot of regions to make it more readable. I love regions. Unfortunately, Visual Studio doesn’t provide a default code snippet to define regions. So I created one for myself. I’m publishing the code because I often change from PC or because of reinstalls etc. The internet is always (or most of the time) available, so I can easily download my snippet from here.

continue reading…

Not that obvious

Setting a RowFilter that compare’s dates, isn’t quite the same as comparing numbers or strings. For starters Date values must be enclosed within sharp characters # #. The date format is the same as the result of DateTime.ToString() method for invariant or English culture.

Alternatively you can enclose all values within single quotes ‘ ‘. It means you can use string values for numbers or date time values. In this case the current culture is used to convert the string to the specific value. But we don’t always know, or want to know, in advance what the current culture is.

continue reading…

The Problem

When I’m in the office, I have to use an authenticated proxy to get outside our intranet and to the internet. When I called a service that resides on the web, I got the 407 error. How can we fix this without having to provide an account to our application?

continue reading…