Posts

Showing posts from 2011

Compare DataColumn to null

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

Get Text Height & Width

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