Some time I see the Server Error message in our SilverNet web based inventory system
I've investigated this problem and found that in the row:
<asp:Label ID="Label3" runat="server" Text='<%# Eval("Paid", "{0:N}") %>' Visible='<%# Eval("Paid")<>0 %>' ></asp:Label>
The field "Paid" can be DbNull.
First, I tried to check the value Paid before using it in the Eval function. But then,I've found very simple solution. I've edited SQL query in the data source. I've changed the "Select Paid ..." on "Select IsNull(Paid,0) As Paid...."
DbNull is an insidious thing!
Subscribe to:
Post Comments (Atom)
Labels
- accounting (1)
- accounting software (1)
- adjusting (1)
- ASP.Net 2.0 (2)
- barcode scanner (1)
- Blog (1)
- classical music (1)
- clothing software (1)
- Excel (1)
- fashion clothes (1)
- free invoice template (1)
- GAE (1)
- Horowitz (1)
- HTML (1)
- HTTPS (1)
- import Excel file (1)
- inventory (2)
- inventory software (1)
- inventory system (6)
- inventory system web based software ASP.Net (1)
- invoice (1)
- meta tag (1)
- mobile wireless inventory software (3)
- MS SQL (1)
- multi location (1)
- music pianist (1)
- music software (1)
- online (1)
- osCommerce (1)
- pen and paper (1)
- physical counting (1)
- piano (1)
- point of sale (1)
- query (1)
- receipt (1)
- reorder point (1)
- software (1)
- system (1)
- warehouse (1)
- warehouse management (1)
- web store (1)
- XML (2)
No comments:
Post a Comment