Search:   Namespaces Discussions .NET v1.1 Feedback

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. Bill Bassler Is there a way to return a null string is a null is returned or the actual value (other than null) when a value is present? myReader[3].ToString(); //returns a empty string when the field returned is null myReader.IsDBNull(3) // returns true when the field returned is a null while (myReader.Read()) { Label1.Text += myReader.GetString(0); // throws an exception when a null value is encountered } Reply to this message...        Bill Swartz I think this answers your question. the IsNull Function in SQL checks for the null value and replaces it with something. ie Select IsNull(myColumn,'Null') from myTable Replaces a null value with the string 'Null' Bill -----Original Message----- From: Bill Bassler [mailto:Click here to reveal e-mail address] Sent: Monday, July 22, 2002 12:07 PM To: ngfx-sqlclient Subject: [ngfx-sqlclient] SQLDataReader: Is there a way to return a null string is a null is returned? Is there a way to return a null string is a null is returned or the actual value (other than null) when a value is present? myReader[3].ToString(); //returns a empty string when the field returned is null myReader.IsDBNull(3) // returns true when the field returned is a null while (myReader.Read()) { Label1.Text += myReader.GetString(0); // throws an exception when a null value is encountered } | [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID | http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT Reply to this message...        Bill Bassler 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] Reply to this message...     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