how to check if cell of gridview is empty?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Bart

    how to check if cell of gridview is empty?

    Hi,

    i need to check wether a cell of a gridview is empty or not. I did this:

    Protected Sub GridView1_Selec tedIndexChanged (ByVal sender As Object, ByVal e
    As System.EventArg s) Handles GridView1.Selec tedIndexChanged
    Dim log1 As String
    log1 = GridView1.Selec tedRow.Cells(1) .Text
    .....

    If log1 = "" Then
    Response.Write( "empty")
    else
    Response.Write( log1)
    end if
    ....


    When log1 contains data, i get it in the response.write, but when the field
    in the sql-database contains NULL or is empty (e.g. by a previous update
    operation), i don't get the expected 'empty'. So log1 = "" is considered
    as false.

    I checked the length with this line: response.write( log1.length)

    This gives the right length when data is present, but gives 6 when it's NULL
    or empty !!

    Is that the default length of the empty cell in a gridview? How to test when
    that cell is empty? (i also tried with IsDbNull but doesn't work either).

    Thanks
    Bart


  • Mark Rae [MVP]

    #2
    Re: how to check if cell of gridview is empty?

    "Bart" <b@b.dwrote in message
    news:etgLRopaIH A.1208@TK2MSFTN GP05.phx.gbl...
    How to test when that cell is empty?
    A quick View Source would have given you the answer...

    When a bound GridView cell contains no data, ASP.NET fills it with &nbsp;

    Hence the length of 6...


    --
    Mark Rae
    ASP.NET MVP


    Comment

    • Bart

      #3
      Re: how to check if cell of gridview is empty?

      Thanks

      "Mark Rae [MVP]" <mark@markNOSPA Mrae.netschreef in bericht
      news:%23vrXCspa IHA.208@TK2MSFT NGP02.phx.gbl.. .
      "Bart" <b@b.dwrote in message
      news:etgLRopaIH A.1208@TK2MSFTN GP05.phx.gbl...
      >
      >How to test when that cell is empty?
      >
      A quick View Source would have given you the answer...
      >
      When a bound GridView cell contains no data, ASP.NET fills it with &nbsp;
      >
      Hence the length of 6...
      >
      >
      --
      Mark Rae
      ASP.NET MVP
      http://www.markrae.net

      Comment

      Working...