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 return value provide you the Height & width as shown below.

sizeDetails.Height // For height

sizeDetails.Width  // For Width

I have seen so many ways to find the string height but this is a best way to find height according to the text font.

Happy Coding :) :)

Maximize child MDI form without ControlBox

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;


Adding text to label using javascript

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...