Professional Web Applications Themes

Checking For Null DB Fields - ASP.NET General

After binding my data to the datalist I have created this function. I am recieving an error: BC30289: Statement cannot appear within a method body. End of method assumed. Does anyone have any clue what is going on here? --------------------------------------------- Function cnCustBullet15(ByVal CustBullet15 As String) as String If IsDBNull(CustBullet15) Return "<tr><td>NULL VALUE</td></tr>" Else Return "<tr><td>" & CustBullet15 & "</td></tr>" End If End Function <asp:Datalist id="customers" runat="server"> <HeaderTemplate> <table border="0"> </HeaderTemplate> <ItemTemplate> <%# cnCustBullet15(Container.DataItem("CustBullet15")) %> </ItemTemplate> <FooterTemplate> </table> </FooterTemplate> </asp:DataList> -- Thanks! Troy...

  1. #1

    Default Checking For Null DB Fields

    After binding my data to the datalist I have created this function. I am
    recieving an error:

    BC30289: Statement cannot appear within a method body. End of method
    assumed.

    Does anyone have any clue what is going on here?
    ---------------------------------------------
    Function cnCustBullet15(ByVal CustBullet15 As String) as String
    If IsDBNull(CustBullet15)
    Return "<tr><td>NULL VALUE</td></tr>"
    Else
    Return "<tr><td>" & CustBullet15 & "</td></tr>"
    End If
    End Function


    <asp:Datalist id="customers" runat="server">
    <HeaderTemplate>
    <table border="0">
    </HeaderTemplate>
    <ItemTemplate>
    <%# cnCustBullet15(Container.DataItem("CustBullet15")) %>
    </ItemTemplate>
    <FooterTemplate>
    </table>
    </FooterTemplate>
    </asp:DataList>


    --
    Thanks!

    Troy





    Troy Guest

  2. #2

    Default Re: Checking For Null DB Fields

    Both of those were correct answers. Thank you. However, I am getting the
    same error. Any other clues?

    --
    Thanks!

    Troy



    "Troy" <devteam.at.cyberwarehouse.com> wrote in message
    news:phx.gbl... 


    Troy Guest

  3. #3

    Default Re: Checking For Null DB Fields

    "Troy" <devteam.at.cyberwarehouse.com> wrote in message
    news:phx.gbl... 

    I have to assume that is is an ASP specific problem, in which case, I would
    ask the ASP.NET Group:

    microsoft.public.dotnet.framework.aspnet


    ~
    Jeremy

    Jeremy Guest

Similar Threads

  1. Checking for NULL value in query
    By cfquest in forum Macromedia ColdFusion
    Replies: 4
    Last Post: August 30th, 07:08 PM
  2. checking for null
    By jones74 in forum Macromedia Flash Actionscript
    Replies: 3
    Last Post: March 5th, 12:40 AM
  3. Replies: 0
    Last Post: November 21st, 04:58 PM
  4. #26351 [NEW]: Incorrect handling of Null Fields/Numerical Fields with '0'
    By jabberwocky at ibplanet dot com in forum PHP Development
    Replies: 0
    Last Post: November 21st, 04:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139