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('<%= this.lblClientType.ClientID %>').value But this wont work as it doesn't contain a property called value. Resolution : document.getElementById('<%= this.lblClientType.ClientID %>').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

Get Text Height & Width

By -
In many cases we tend to work with dynamic data transaction & data formatting, then we maty need to calculate the width, height & align accordingly w.r.t  specific  font details etc.,,,,, I got in to same scenarios, where i need to brush the text on a image & i was breaking my head how to calculated the starting point w.r.t text size, font   etc.,,,,,,,,,, after a long of R & D ; got something which saved me i.e., Graphics class (which is a dotnet inbuilt class) Usage : Creating a instance Graphics   grpControl = CreateGraphics(); Creating a dummy string value String   minstr =”Minimumvalue”; Font details I will be working with Font   textFont   =   new   Font ( "Arial" , 16,   GraphicsUnit .Pixel); Now the destination of calculation, graphics Class has a method named MeasureString this is return value of type    SizeF SizeF: It stores the floated points SizeF   sizeDetails = grpControl.MeasureString(minStr,textFont); Now the r
Read more