Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by GeertVerhoeven

  1. GeertVerhoeven

    Error when using Method Extensions

    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
  2. GeertVerhoeven

    Error when using Method Extensions

    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 /...
  3. GeertVerhoeven

    Possible to force attribute depending on the value of a different one

    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...
  4. GeertVerhoeven

    UnauthorizedAccessException

    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")...
  5. GeertVerhoeven

    Exam difficulty: Your opinions

    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
  6. GeertVerhoeven

    XML comment in dll

    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...
  7. GeertVerhoeven

    Exam difficulty: Your opinions

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

    Function that returns a table and used in the from clause

    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...
  9. GeertVerhoeven

    Adding Nested Join with Temp Table Result

    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...
  10. GeertVerhoeven

    Microsoft SQL 2005 Server Asp.net

    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...
  11. GeertVerhoeven

    Creating database diagram

    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
  12. GeertVerhoeven

    Adding Nested Join with Temp Table Result

    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 @...
  13. GeertVerhoeven

    Save Report Wizard Template?

    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...
  14. GeertVerhoeven

    Cast a NCHAR14 to a DateTime

    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...
  15. GeertVerhoeven

    Valid Software

    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
See more

Part and Inventory Search

Back
Top