how to bind the label to gridview

Question

hi how to bind the label to gridview when that mobile value is null from database then that label is not display or not bind to gridview

Dorababu Meka · Answer

Hi prathyusha have you tried as per said does this works?

Dorababu Meka · Answer

Try this which works for me '> in place of call add your database column name

prathyusha · Answer

first of all i kindly say to many thanks for your patience. still it's not working

Santhosh Kumar Jayaraman · Answer

This thread is going very long.. the same piece of code is working in my project. I cant say exact issue unless i debug the project. The other way is can you set Null for Mobile column instead of 'null' in database update table1 set Mobile=NULL where mobile='null' and in UIcheck DbNull.Value?false:true

prathyusha · Answer

' Text=Call :> it's not working in my database mobile is null and mobile datatype is nvarchar(255) and i changed null to NULL it is also not working

Santhosh Kumar Jayaraman · Answer

OK..In database you are saving it as null and not NULL. when you say null in varchar column then it becomes some value and it is really not null. Either update your column to Null instead of 'null' or in label change the condition to null as below. null ? false: true %>' Text=Call :>

prathyusha · Answer

i'm attaching my dbfile in my db it's null only so please help me

Santhosh Kumar Jayaraman · Answer

Thats because from DB you might getting Dbnull Try this DBNull.Value ? false: true %>' Text=Call :>

prathyusha · Answer

hi your code is working but when i'm using database it's not working here i'm ataching two rar files please chek it and send me the code

Santhosh Kumar Jayaraman · Answer

You tried my project as well? i have changed it to framework 3.5 and its working.

prathyusha · Answer

it's not working i'm using framework 3.5

Santhosh Kumar Jayaraman · Answer

have you tried my previous code? ' Text=Call :> this should be working..I have attached a sample project in which am setting mobile property to Null . And in the visible am checking for ==null. now call label is not displayed for me. In your case if your getting Dbnull then compare with Dbnull.Value instead of null in my code. I attached sample project. run it and check the difference.

prathyusha · Answer

here i'm attaching .csaspx and output file

prathyusha · Answer

thank you santhosh But i want to use the label text is static like based on that call value from database it display or not like if CALL:NULL it doesn't display in gridview(with call also not display i mean static text) if CALL:9874563210 it bind to the gridview or display Please help me

Santhosh Kumar Jayaraman · Answer

ok i believe you want to set the lable visibility to false. Try this ' Text=Call :>

Neha Sharma · Answer

Hi you can mention text of label like Text=' ' or can take it in columns -> aspboundfields like: SortExpression=ID Visible=False/>

prathyusha · Answer

new folder rar attachment check it once plesae

Santhosh Kumar Jayaraman · Answer

attaCHMENT is missing

prathyusha · Answer

hi i am attached the output file in that where call:null is not display because the call value is null when call has value that would be bind to gridview so please check it once and send me the code

prathyusha · Answer

Thank u for answer santhosh but i don't want to display this also when call is null like Call :null if data then display like Call :9849009566 by using your method if call is null it display like Call :null i don't want to display that in grid view please help me it's urgent

Santhosh Kumar Jayaraman · Answer

You are using the below method? public string ProcessMyDataItem ( object myValue ) { if ( myValue == null ) { return 0 value ; } return myValue . ToString (); }