Recent content by GeertVerhoeven

Thanks Jel. I think that will be the reason. It does work when I give the method a different name. I've found some extra info as well: http://www.msdner.com/dev-archive/161/153-1016-1615497.shtm Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog

Hi all, I'm practicing with the C# 3.0 Language Enhancements and get stuck with the following issue on method extensions. The goal is to write an Equals method for the datetime type which accepts an additional parameter indicating until which level the comparison must be done (Year / Month /...

Hi all, I'm currently creating an XSD to validate my xml file. I wonder wheter it is possible to force a set of attributes depending on the value of a different attribute? For example I have the following XML structure: <charColumn columnName="" maxLength="" allowDbNull="" /> <numberColumn...

Normally the above code will not compile since the TextReader class has no WriteLine method. You should change your code like this by using StreamWriter and TextWriter: string drive = "c"; TextWriter tw = new StreamWriter(String.Format(@"{0}:\boot.ini.zives", drive)); tw.WriteLine("test")...

Last friday I passed the 70-536 and give it **. If you study with the MS PRESS book, it should be relative easy. Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog

Hi, If you want to have intellisense, you need to make sure that the xml document is generated for the class library. You can set this via Project Properties in the Build Tab (XML Documentation file). If you then rebuild your project and update the reference, it should work. NOTE: the...

I passed the 70-300 a while ago and give it a *** exam Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog

Hi all, For one of my project I needed a function that returns a table based on some parameters. In SQL Server this is pretty easy but in Oracle it took me quit some time. Therefor I've posted a sample on how to do it on my blog...

It should be something like this: (not tested since no SQL at the moment) SELECT T1.CUSTNMBR, T1.CHEKNMBR, T1.RMDTYPAL, T1.DOCDATE, T2.APPTOAMT FROM ( SELECT RM20101.CUSTNMBR, RM20101.CHEKNMBR, RM20101.RMDTYPAL, RM20101.DOCDATE...

This should get you started: It shows you how to create a new database with SQL Server Management Studio. http://msdn2.microsoft.com/en-us/library/ms186312.aspx If you have installed an express edition without the management studio, you first need to install it...

Hi, You can set this in the Database\Options\Document menu. In the Table tab you can set how the datatype needs to be shown. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog

Hi, It is not possible to join the result of a stored procedure with a table. You can do 2 things: - Create a function in case of a stored procedure. A function can be used as a normal table. - Include the extra join in the stored procedure Greetz, Geert Geert Verhoeven Consultant @...

Hi, I have created my database diagram with Visio. Each time I want to export a report from the database via the Report Wizard, I need to specify the fields I want to include. Is there a possibility to create a personal template to be used to export the database diagram? The version I'm using...

Hi, You can use the following function: create function dbo.ConvertToDatetime (@inputString nchar(14)) returns datetime as begin declare @hourString varchar(8) set @hourString = substring(@inputString, 9, 2) + ':' + substring(@inputString, 11, 2) + ':' + right(@inputString, 2) return...

Hi, I think that you can best ask this question to someone at Microsoft. It is strange that someone is selling its license. I'm not even sure if it is allowed. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog