Compare DataColumn to null

By -

Hello all,

Today i got struck in a way how to compare a null value which is coming from database in a dataset........


 tried few ways, like this
     
             
             Object.Equal(ds.Tables[0].Rows[0]["date],null)
             ds.Tables[0].Rows[0]["date] == null
             Object.ReferenceEquals(ds.Tables[0].Rows[0]["date],null)

but nothing worked ......
at last after a cup of Cappuccino something clicked me & made me feel how stupid my thinking was
because this is DBNull type & I  am trying to compare with a different object ……..

so finally it worked like this

              value.Equals(System.DBNull.Value)

Hope this helps someone J

Comments

Post a Comment

Popular posts from this blog

Maximize child MDI form without ControlBox

By -
Problem: When we try maxing the form as maximum mode using control box buttons , then every thing goes fine and it be maximized and can see the toolbar below. But when we try doing the same with with controlbox = false( this will hide the control box), now if you try making the for to maximize, it will be maximized but it will also hide the toolbar below. When we hide the control box the form will be maximize to the whole screen ( hiding the system toolbar). Solution: Hide the control box on page Code : Please paste this code in form load method In VB Me.ControlBox = False In C# this.ControlBox = false;
Read more

Adding text to label using javascript

By -
While accessing label value from JavaScript, we try like this document.getElementById(' ').value But this wont work as it doesn't contain a property called value. Resolution : document.getElementById(' ').innerHTML Reason: Because when we see the page source, label is been converted to span, where as textbox is converted to input control asp:label to span control asp:textbox to input of type "text" Please provide the comments, if any...
Read more

Difference between XmlNode and XmlElement

By -
XmlElement is derived from XmlNode (XMLElement is a type of XMLNode) and it is having more functionalists than xmlNode XmlElement can be used if you are more specific with XML. Please find all the Node types Node Types The following table lists the different W3C node types, and which node types they may have as children: Node type Description Children Document Represents the entire document (the root-node of the DOM tree) Element (max. one), ProcessingInstruction, Comment, DocumentType DocumentFragment Represents a "lightweight" Document object, which can hold a portion of a document Element, ProcessingInstruction, Comment, Text, CDATASection, EntityReference DocumentType Provides an interface to the entities defined for the document None ProcessingInstruction Represents a processing instruction None EntityReference Represents an entity reference Element, ProcessingInstruction, Comment, Text, CDATASection, EntityRe...
Read more