Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#2.0 ASP.NET ADO.NET
Hi guys:
 
I want to assign value to label.text form database
but if the value is null i want to assign specific value to the label.text
 
in brief code like that:
 
if (UserProfileInformation.Tables[0].Rows[0].IsNull("UserFirstName"))
        {
            UserFirstNameData.Text = "not found";
        }
        else
        {
            UserFirstNameData.Text = UserProfileInformation.Tables[0].Rows[0]["UserFirstName"].ToString();
        }
 
that code work good ,
but it somewhat long and i have many labels on the page ,
so i want gentle and simple code if it could possible
 
thanks........
Posted 19-Dec-10 9:00am
Edited 19-Dec-10 9:01am
v2

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

No too difficult
 
private static void CheckForNull(object obj, Label label, string text)
{
  string labelText = text;
  if(obj != DbNull.Value)
  {
     labelText = obj.ToString();
  }
 
  label.Text = labelText;  
}
 
CheckForNull(UserProfileInformation.Tables[0].Rows[0]["UserFirstName"],
UserFirstNameData, "not found");
  Permalink  
Comments
MrProgrammer_78 at 19-Dec-10 18:10pm
   
Thank you very much.......... very nice and gentle code

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web03 | 2.8.150305.1 | Last Updated 19 Dec 2010
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100