Sometimes Convert.ToInt32(object) will work and other times (Int32)object will work. How do you know which to use? I usually try one and if it doesn't work use the other but I'm sure that's not the best approach.
View 4 Replies
I am writing unit tests for fluent Nhibernate, when I run the test in isloation it passes, but when I run multiple tests. or run the test more than once it starts failing with the message below System.ApplicationException : For property 'Id' expected '1' of type 'System.Int32' but got '2' of type 'System.Int32'
[TextFixture]
public void Can_Correctly_Map_Entity()
{
new PersistenceSpecification<UserProfile>(Session)
.CheckProperty(c => c.Id, 1)
.CheckProperty(c => c.UserName, "user")
.CheckProperty(c => c.Address1, "Address1")
.CheckProperty(c => c.Address2, "Address2")
}
How to convert string value to int32.
In timsplit i have value "17:00 - 2:00".Then i am converting it TimeIn and TimeOut.TimeIn is string now and how to convert it to int32.I am getting error while convertin
Timesplit = strResultData.Split('-');
string TimeIn = Timesplit[0];
string TimeOut = Timesplit[1];
int TimeI = Int32.Parse(TimeIn);
What should the int size be for a Int32 in a CMD parameter
[Code]....
Currently i using gridview to display a person informaton based on his login id however it show error because the session is set to ToString. Is it a way to convert the session to int32?
[Code]....
I am passing query string and the url is as follows-> http://localhost:1086/Web/EditMobile.aspx?sno=2. But when i try to enter the url as follows,localhost:1086/Web/EditMobile.aspx?sno=2*3424324423432424* , i get the following error->Value was either too large or too small for an Int32. How do i handle this error. I must get an error report like " the value is not found in the table or database"
View 1 RepliesI am facing problem while executing followinf linq query ..
[Code]....
Here i feel that problem is due to
[Code]....
method , this method is private method return for fetching age of the user based on the birthdate of the user..
I'm using a GridView control to edit data in a MySQL database.
I've created the C# code behind but I'm having trouble pulling back the parameter from a radiobutton control to populate an Int32 field in the database. I'm getting "Input string not in correct format"This is the particular bit (amongst a host of others of the same type) that is causing the problem:
cmd.Parameters.Add("?yes", OdbcType.Int).Value = (Convert.ToInt32(((RadioButton)GridView2.Rows[i].FindControl("edYes")).Text));
I am not sure where my app is failing but most probably this is where it is failing.. I think lblExpID.Text is the culprit. Here's the relvant part of my code:
Dim lblExpID As Label
For Each item In LSGrid.Rows
lblExpID = item.FindControl("lblID")
If txtExpGenFund.Text <> "" Then
sqlArray(i) = ExpDetailsID & "," & (lblExpID.Text) & "," & MunID & "," & _
Val(txtExpGenFund.Text) & "," & Val(txtExpDetSpecialRevenue.Text) & "," & _
Val(txtExpDetCapitalProjects.Text) & "," & expTotal & "," & reportingYear & "," & "Test Comments" & "," & UserID
End If
Can u help me identify why i am getting this error looking at the sp below:
PROCEDURE [dbo].[uspEXPENDITURE_DETAILS]
(
@ExpDetailsID int=0 output,
@ExpDet_ExpID int,
@ExpDet_Municipality_ID nvarchar(50),
@ExpDetGeneralFund money,
@ExpDetSpecialRevenue money,
@ExpDetCapitalProjects money,
@ExpDetTotal money,
@Exp_Reporting_Year varchar(10),
@ExpComments varchar(max),
@Contact_ID int
)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
delete from [dbo].[TBL_EXPENDITURE_DETAILS] where ExpDet_ExpID=@ExpDet_ExpID and ExpDet_Municipality_ID=@ExpDet_Municipality_ID and Exp_Reporting_Year=@Exp_Reporting_Year
If @ExpDetailsID >= 0
Begin
INSERT INTO [dbo].[TBL_EXPENDITURE_DETAILS]
([ExpDet_ExpID]
,[ExpDet_Municipality_ID]
,[ExpDetGeneralFund]
,[ExpDetSpecialRevenue]
,[ExpDetCapitalProjects]
,[ExpDetTotal]
,[Exp_Reporting_Year]
,[ExpComments]
,[ExpDetCreatedBy]
,[ExpDetCreateDate])
VALUES
(@ExpDet_ExpID,
@ExpDet_Municipality_ID,
@ExpDetGeneralFund,
@ExpDetSpecialRevenue,
@ExpDetCapitalProjects,
@ExpDetTotal,
@Exp_Reporting_Year,
@ExpComments,
@Contact_ID,
GetDate()
)
SET @ExpDetailsID = SCOPE_IDENTITY()
return @ExpDetailsID
end
I have a master/detail scheme for editing an asp:GridView using an asp:DetailsView. One of my fields is for a phone number of type int64 (always 10 digits). I would like this field to always be displayed as (###)###-####. My issue is the first digit in the phone number is always truncated for my edit item field which I used a MaskedEditExtender to achieve the formatting.
Here is my EditItemTemplate for the details view:
<cc1:MaskedEditExtender TargetControlID="edtPROJ_Leader_Phone" Mask="(999)999-9999" runat="server" ClearMaskOnLostFocus="false" ClipboardEnabled="true" MaskType="Number" />
<asp:TextBox ID="edtPROJ_Leader_Phone" runat="server" Text='<%# Bind("PROJ_Leader_Phone") %>' ></asp:TextBox>
When my details view is displayed for editing, the text box displays(_23)456-7890 for the integer 1234567890. Also worth noting that if the property MaskType="Number" is removed, the textbox shows:
(234)567-890_. I would of course have the textbox show (123)-546-67890 after binding.
I have a database table with all columns to allow nulls for testing purposes. Between all of my columns I have int, varchar or bit datatypes. When I try to submit the form I get the following error message:
Value was either too large or too small for an Int32.
Here is the code:
using (storeDataContext db = new storeDataContext())
{
db.Dealerssses.InsertOnSubmit(new Dealersss [code]....
I am trying to get a sample project to work with dotnetopenauth and facebook.I have this code
namespace OAuthClient
{
using System;
[code]...
the maximum number of files in a folder, I noticed that DirectoryInfo.GetFiles().Length is returning a System.In32, but the Maximum value of a Int32 is 2.147.483.647 (Int32.MaxValue) while on NTFS (an many other filesystems) the maximum number of files can go far beyond that.
on NTFS it is 4.294.967.295 single files in one folder (probably an Uint32)
Which leads me to the interesting question:
Is it possible to get the number of files in a folder on NTFS with the .NET framework, when the number of files exceeds the Int32.MaxValue, in an elegant and performing manner?
I am working with MVC2 and one of the view model's properties is IDictionary<Int32, String>.
This is not to be changed on the view. But when the form is posted back I would like to still get those values.
Can Html.Hidden store this property values?
How should I do this so the model still gets the IDictionary<Int32, String> values on the POST action?
I swear I'm overthinking this as I've tried different combinations to do an insert from Code Behind to my Sql DB.
This is what my table looks like:
[Code]....
My code behind:
[Code]....
I suspect that the problem may be my date. The format that goes from the UI is mm/dd/yyyy.
I got the following error when i tried to insert a new record after the run my project, so what does this error indicates?
"{"Cannot insert explicit value for identity column in table 'Articles' when IDENTITY_INSERT is set to OFF."} System.Exception {System.Data.SqlClient.SqlException}
"
When i click on the page that represents a controller the following error was displayed:-
"The null value cannot be assigned to a member with type System.Int32 which is a non-nullable value type"
On this link of code
var articleapproval = articletyperepository.FindAllArticlesRequireMyApproval().ToList();
while the FindAllArticlesRequireMyApproval execute the following LINQ statement :-
var articleapproval= articletyperepository.FindAllArticlesRequireMyApproval().ToList();
where this methods calls the following LINQ statement:-
My code:
[Code]....
If the value is null writes out that error.How to check if the value is null? And if the value is null, I want to store + 1
I got this error message when I use rowfilter
Line: 938 Error: Sys.WebForms.PageRequestManagerServerErrorException: Cannot perform '=' operation on System.Int32 and System.String.
My code is like this
[Code]....
When I check only string, it's okay
But I have to check string and int because some columns are only Integer such as LLMS_Id, Risk, RsidualRisk
I am using Entity Framework to contact my data base. as part of my web code I am using Linq to entities, and I want to determine the number of elements in an anonymous type list. I can't get it to work, I get the exception: "LINQ to Entities does not recognize the method 'Int32 Parse(System.String)' method, and this method cannot be translated into a store expression."
var questItem = from chapters in context.TestChapter
from questions in context.Question
where chapters.ID == int.Parse(Request.QueryString["id"])
where questions.TestChapterID == chapters.ID
select questions.ID;
int numOfSteps = questItem.Count();
how can I get it to work?
i work with visual studio 2005 and asp net 2.0. i have a method method as this :
[Code]....
this problem is follow if i run the web method and don't enter a string and a int a receive this message : System.ArgumentException: Cannot convert to System.Int32. ok when i arrive in the method i can check if lists is empty but how i can do if int is NULL because i don't want to returns a error if people run my web method and don't enter the parameters.
Whats the best method of casting. I've been using syntax like this:
Button btnSubmit = (Button)item.FindControl("Btn_Submit")
but is this better or just different:
Button btnSubmit = item.FindControl("Btn_Submit") as Button
I'm using linq to sql to populate a list of objects. One of the fields I'm interested in is stored as a tinyint. How should I declare this property type in my object definition? As a Short? Byte? Int16?
View 4 RepliesI have this problem where I am passing NVARCHAR parameter to a stored procedure, and the field type in the table for that parameter is INT.
I am doing that because I am using IN function, and for example if I want to send multiple parameters, that is the only possible way to do through .NET. Or not? The SP doesn't get executed because of the wrong type, and I am trying to cast the value, but I get an error. Here is how I am trying:
Example:
@Parameter nvarchar OrderStatusID = ('30, 40')
(o.OrderStatusID IN (CAST(@OrderStatusID as int)) OR @OrderStatusID IS NULL)
Is there a way to cast each value separately, or what will be the best way to cast whole value as INT.
I am pulling a 'long' value from Session, using a generic property, and it is crashing. so I have:
public static T Get<T>(string key)
{
if(...)
return (T)System.Web.HttpContext.Current.Session[key];
...
}
When debugging, the value is 4, and it crashes.
