Avoid Error Message Due To Null Vs Integer Incompatibility
Sep 26, 2010
I receive the error message below, I think because the database field in question is null (I realize I probably should not allow null values, but I can't even display the page to allow the user to enter a value---and I would prefer not to enter a default value in SQL).
How do I avoid this error message? If the column is null (and it is supposed to be an integer), do I need to change the value to something like "0" in the code behind---or is there any easier way to do this right in aspx page (see source of error message below)? Either way, I'm not sure how to do either (I can't get any such lines of code to work here). Object cannot be cast from DBNull to other types.
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidCastException: Object cannot be cast from DBNull to other types.
Source Error:
[Code]....
View 9 Replies
Similar Messages:
Jan 7, 2011
I do have a log system and the correct error is well explicit there, but I want to give a better message to the user.
I keep trying several ways but I'm using Telerik components and well jQuery and I ended up using both ASP.NET Ajax methods and jQuery, so I use
function pageLoad() {
try { [code]....
as well$(document).ready(function() { ... }
that alert(err) is never fired even upon OnClick events
what's the best approach to avoid this message errors and provide a cleaner way?
all this happens in <asp:UpdatePanel> as I use that when I didn't know better (3 years ago!) and I really don't want to mess up and build all again from scratch
Updated with more error windows after volpav solution
View 3 Replies
May 18, 2010
I think the popup message is a poor idea because OnClientUploadError has already provided developers a good option to handle the error easily in whichever way they prefer. The worst is that if a user clicks OK, he will see a window that should be seen only by software developers. Is there any trick to stop the error alert?
View 9 Replies
Feb 4, 2010
if i implement updateprogress in my web page i got the following error messge
Microsoft JScript runtime error: 'Sys.WebForms.PageRequestManager' is null or not an object
.aspx
<link
href="cssUpdateProgress.css"
rel="stylesheet"
type="text/css"
/>
<script
type="text/javascript"
language="javascript">
var ModalProgress =
'<%= ModalProgress.ClientID %>';
</script>
<asp:ScriptManager
ID="ScriptManager1"
runat="server"
EnablePartialRendering="False"
LoadScriptsBeforeUI="False"
ScriptMode="Release"
>
<
</asp:ScriptManager>script
type="text/javascript"
src="jsUpdateProgress.js"></script>
<asp:Panel
ID="panelUpdateProgress"
Width="105px"
Height="25px"
runat="server"
CssClass="updateProgress">
<asp:UpdateProgress
ID="UpdateProg1"
DisplayAfter="0"
runat="server">
<ProgressTemplate>
<table
style="height:25px;">
<tr><td><img
height="21px"
width="15px"
src="imagesprocessing.gif"
style="vertical-align: middle"
alt="Processing"
/></td><td
valign="middle"
>Processing...</td></tr>
</table>
</ProgressTemplate>
</asp:UpdateProgress>
</asp:Panel>
<cc1:ModalPopupExtender
ID="ModalProgress"
runat="server"
TargetControlID="panelUpdateProgress"
BackgroundCssClass="modalBackground"
PopupControlID="panelUpdateProgress"
/>
javascript
Sys.WebForms.PageRequestManager.getInstance().add_beginRequest(beginReq);
Sys.WebForms.PageRequestManager.getInstance().add_endRequest(endReq);
function
beginReq(sender, args) {// shows the Popup
$find(ModalProgress).show();
}
function
endReq(sender, args) {// shows the Popup
$find(ModalProgress).hide();
}
View 1 Replies
Jan 28, 2010
how can insert null value into integer field
View 3 Replies
May 3, 2010
i have some problem in passing null value to an integer datatype in sql. Here is my code:-
[Code]....
The if statement within query is where i am having problem!
View 2 Replies
Mar 29, 2010
I have an sproc which selects data out of my table. The column can return integer or NULLs.
I get the 'failed to enable constraints error' when databinding. If I go to my tableadapter and select my column there is a NullValue property which has 'Throw Exception, Null, Empty'. If I try and unset the exception option it tells me only strings are allowed this. However the 'AllowDBNull' option is set to TRUE.
What is the alternative and will this be fixed in 2010?
View 1 Replies
Jan 25, 2011
i have atable:
STDNo nvarchar(6) //student number primary
CID nvarchar(7) //course ID primary
DNo int //Department Number primary
H1 int allow null // Home work 1
H2 int allow null
H3 int allow null
H4 int allow null
H5 int allow null
Q1 int allow null //Quize 1
Q2 int allow null
Q3 int allow null
Q4 int allow null
Q5 int allow null
HE1 int allow null
HE2 int allow null
FExam int allow null // Final Exam
and stored procedure like this:
ALTER procedure [dbo].[AddMonthlyMarks]
(
@STDNo nvarchar(6),
@CID nvarchar(7),
@Dno int =isnull,
@H1 int,
@H2 int,..........................
the Data key name of grid is STDNo the problem is that the instructor this month will add only homework1(h1) for specific student number or to all students and rest of home works and quezies will not entered (Null), to the next month he will enter home work 2 ,etc... i get an error and i think that the null values for others home works in grid make this error caution: in table i check allow null property,the data type is integer How i can convert this null values to integer?
View 5 Replies
Sep 24, 2010
Menu control is not compatibile with IE8. Is there a fix for this problem? When you open the application in IE8 it only shows menus in two lines and you cannot click on it. And then it displays a white screen. I think that I implemented a meta tag at the time setting compatibility to IE7 but it does not seem to work.
View 11 Replies
Nov 18, 2010
I have a user control with GridView. GridView template has label that suppose to get custom object value Name.
aspx:
<asp:Label ID="lblImage" runat="server" Text='<%# MyData.Name%>' />
cs:
public MyObject MyData;
During page loading MyData object is null, so I'm getting exception: "Object reference not set to an instance of an object.".
How to avoid the error?
View 5 Replies
May 25, 2010
This is what I have implemented, for further code, how to send the text of the text box to the server to store in variable or database without post back? It can be done by using Ajax and update plane, but I would like to implement it using a JavaScript script.
<div id="CommentID" style=" width:30%; height:30%">
<asp:Button ID="Button1" runat="server"
Text="Comment"
OnClientClick="visibleDiv('id1'); return false;" />
<div id="id1" runat="server" style="visibility: hidden; background-color:Green; width:100%; height:100%">
<asp:TextBox ID="TextBox1" runat="server"
AutoCompleteType="Disabled" Rows="3"
TextMode="MultiLine" Width="98%">
</asp:TextBox>
<asp:Button ID="Button2" runat="server"
Text="Post"
onclick="Button2_Click" />
<asp:Button ID="Button3" runat="server"
Text="Cancel"
OnClientClick="visibleDiv('id1'); return false;" />
</div>
</div>
View 2 Replies
Sep 1, 2010
I have a table named [vacation time] with the colums startdate and enddate the table is conected with the [permits table]with the colums permname and permdays(int). i have to create a warning message for the user if the ((startdate)-(enddate)>permday) to avoid the update statement in my grid view.
View 2 Replies
Apr 19, 2010
I have forgotte password page in my application,page have one textbox to insert email address,when user click on submit button if inserted email address (i.e. abc@gmail.com) does not exits in DB it will give custome error message like "Email ID not available".after that suppose user will enter inproper email address (aaa#gmail.com) than client side validation for regular expression will file "Email id not valid",at same both message be on screen,now i want only one message at a time.so please can you help me for same
View 2 Replies
Aug 19, 2010
i am using create user wizard and capturing other information within content template when a new userregisters. Some of the textboxes are binded to required field validators.there is a validation control on the page and ShowMessage box is True.If they dont complete some of the text boxes then the message box pops Up with the error message.It does not however include information errors like "User already exists" or Email address already existsfrom the create user wizard membership UserName and Password Textboxesis it possilbe to hook all of these up so I get one message box with all errors including membership ones?
View 3 Replies
Apr 1, 2010
By default in login template, in case user key in the wrong user name or password, the literal message will show the default error message, "Your login attempt unsuccessful..."What i trying to do is, I have a function in my system to disapprove a member, after the member is disapproved, he/she will not allow to login anymore. When the user trying to login, the default literal msg will show out. Is there any way i can do it more specifically like if the user enter the wrong password only, the literal msg show: "Wrong password entered" insteaed of the default msg?
Same goes to the change password control, for any error msg it just show the long msg but does not tell user whats wrong with the entered valueim trying to do something like if the user enter the wrong password, the literal msg show the one i wan to show.
View 5 Replies
Nov 11, 2013
no Massagebox not working in the web
at catch I want appear windows and retuen to....
try
{
}
catch (Exception ex) {Console.WriteLine("Error reading from", ex); }
View 1 Replies
Jan 16, 2011
I have tried in many way but the error message for custom validator is not shown in validation summary but it(ValidationSummary) shows error message for every other type of validator.
[code]....
View 1 Replies
Aug 7, 2010
I am trying to send the message(complex type) to the message queue.I am getting the error,ETravel.Web, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' is not marked as serializable.below lies the code for that.
public void QueueMessage(EmailMessage message)
{
Message msg = new Message();
msg.Body = message; [code]...
View 1 Replies
Feb 7, 2011
I was wondering if someone could point me in the right direction:
How do I generate a custom error page with the error message and get it to mail me that error message?
Is there a good tutorial out there that someone could point me 2.
View 4 Replies
Dec 9, 2010
I have a datagridview inserted into the form, and sometimes I need that some fields stay in "blank", but with "Null", I tried to use that in the edition columns part
<asp:BoundField DataField="Line" SortExpression="Line" HeaderText="Line"
NullDisplayText=" " />
But when I click on the button "upload", it insert on the field the value of "Null" despite the code, and I have to correct that directly in the server, opening the table and adding a space into the field and then the null value is in "blank"
Actually I was attemping with this second option
<asp:BoundField DataField="Linea" SortExpression="Linea" HeaderText="Linea"
NullDisplayText="N/a" />
And when I click on the upload button, it is continuing saving "Null" and not "N/a", of course I would like the first option
View 2 Replies
May 26, 2010
In my web application, I have a search form. I add information in the boxes provided / select values from ddls and then click the Search button. The search results are loaded on the same page. Now I change the search criteria and click the Search button again. This reloads the same page with new set of results. Now if I click browser back button, I get "Webpage has expired" message. The complete message is as following:
Webpage has expired Most likely cause:
The local copy of this webpage is out of date, and the website requires that you download it again. What you can try: Click on the Refresh button on the toolbar to reload the page. After refreshing, you might need to navigate to the specific webpage again, or re-enter information.
If I click browser back again then page loads resetting the search criteria. Is there any way to avoid this "Webpage expired" message? I am okay even if the page reloads by resetting the search criteria.
View 2 Replies
Sep 22, 2010
I am getting this error:
[Code]....
in my application for a module that displays detailed data in a tab control. I think I have determined the TabContainer1 is the name of the "This" element that is having the issue. I figured this out by debugging the ScriptResource.axd file. Here is the offending lines of code:
[Code]....
The way the app works is there are two modules that work together on the page. One is a selection grid and the other the detail form which shows the details from the selected item in the selection grid. If a user is in a limited role they can only see the data of the default selection and they do not see the grid to select from. It is under this circumstance that I get the error and the detailed module is not rendered. However if I break the code and skip over line 139 to line 140 the detailed information shows correctly. Otherwise I do not even see the detailed form. Based on that I know the detail form is working correctly but is not rendered after this error occurs. In addition I am using this same logic with another detailed pain that works correctly under both roles.
I can not seem to narrow in on any code that is causing the issue. For one thing I have no idea as to where the ScriptResource.axd is created. I also do not see where there is any settings for the tab control for submitions and I am not able to find an "OnSubmitStatements" in my code.
View 1 Replies
Dec 13, 2010
I have this code..
[code] ...
I am checking this on my telerik grid..I have add new button on my telerik grid when I click add new I can able to insert new record but here my validation message are showing minmum and maximum length perfectly..but if I dint enter anything when I hit insert my validation message showing me as'{ Property name }' should not be null?I dont know why my RequiredMessage is not working on my Empty Textboxes?
View 1 Replies
Jan 8, 2010
I have the following class... Compiler Error CS1061 / how to avoid it
[code]....
View 2 Replies
May 17, 2010
m getting this error again and again. i m also using the ajax modalpopup extender in my page ..
View 3 Replies
