Search:   Namespaces Discussions .NET v1.1 Feedback

SV: Re: SQLDataReader: Is there a way to return a null string is a null is returned? Messages   Related Types This message was discovered on ASPFriends.com 'ngfx-sqlclient' list. =?iso-8859-1?Q?Andr=E9_Colbi=F6rnsen?= Bill, that is not correct, the SqlDataReader indeed has an .item pty. I am using both that and IsDBNull in this context with great success: If IsDBNull(myReader.Item("strFalt0" & i.ToString)) Then ....etc Regards/Halsningar Andre Colbiornsen -------------------------------------- Sonnenburg Communications Bergsgatan 3, SE-211 54 Malm=F6 Sweden Tel.: +46-(0)40-97 78 80 Fax.: +46-(0)40-97 78 80 Mob.: +46-(0)708-97 78 79 Mail: Click here to reveal e-mail address Web.: www.sonnenburg.se ---------------------------------------- B2B Web Solutions - Specializing in .Net ---------------------------------------- -----Ursprungligt meddelande----- Fr=E5n: Bill Bassler [mailto:Click here to reveal e-mail address]=20 Skickat: den 23 juli 2002 13:16 Till: ngfx-sqlclient =C4mne: [ngfx-sqlclient] Re: SQLDataReader: Is there a way to return a null string is a null is returned? FYI The SQLDataReader doesn't have an Item property and only has a IsDBNull method which returns a Boolean value indicating whether an expression evaluates to the System.DBNull class. I did find the the "equivalent" of the VB variant type which returns a string denoting a null if null, else returns the value. Also: The ToString method returns a blank string? for a NULL value or the value. myReader[3].ToString() "Bill Swartz" <Click here to reveal e-mail address> wrote in message news:687034@ngfx-sqlclient... [Original message clipped] | [ngfx-sqlclient] member Click here to reveal e-mail address =3D YOUR ID=20 | http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp =3D JOIN/QUIT Reply to this message...        Alex Lowe Andre is right that the SqlDataReader does have an Item property (http://msdn.microsoft.com/library/en-us/cpref/html/frlrfsystemdatasqlcl ientsqldatareaderclassitemtopic.asp).=20 The confusion usually stems from the fact that the Item property appears not to exist in C# but it does appear to exist in VB.NET. Well, the Item property in C# appears in the form of an indexer AND an actual property called Item. What does this mean? Well, it means that you can access (in C#) the Item property like this: //This is actually using the default indexer=20 //(aka the Item property) for the SqlDataReader myString =3D myReader[3].ToString(); And with VB.NET the same thing looks like.... myString =3D myReader.Item(3).ToSTring() Alex - AspFriends.com Moderation Team Microsoft MVP - ASP.NET *********************************************************** Translate C# code to VB.NET code at http://aspalliance.com/aldotnet/examples/translate.aspx *********************************************************** [Original message clipped] Reply to this message...        Bill Bassler Thanks! That clears up my confusion. "Alex Lowe" <Click here to reveal e-mail address> wrote in message news:687336@ngfx-sqlclient... Andre is right that the SqlDataReader does have an Item property (http://msdn.microsoft.com/library/en-us/cpref/html/frlrfsystemdatasqlcl ientsqldatareaderclassitemtopic.asp). The confusion usually stems from the fact that the Item property appears not to exist in C# but it does appear to exist in VB.NET. Well, the Item property in C# appears in the form of an indexer AND an actual property called Item. What does this mean? Well, it means that you can access (in C#) the Item property like this: //This is actually using the default indexer //(aka the Item property) for the SqlDataReader myString = myReader[3].ToString(); And with VB.NET the same thing looks like.... myString = myReader.Item(3).ToSTring() Alex - AspFriends.com Moderation Team Microsoft MVP - ASP.NET *********************************************************** Translate C# code to VB.NET code at http://aspalliance.com/aldotnet/examples/translate.aspx *********************************************************** [Original message clipped] Reply to this message...     System.Data.SqlClient.SqlDataReader System.DBNull Ad MBR BootFX Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd. Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com