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);
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 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.
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 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 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
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 Repliesi 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.
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 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")
}
on VWD 2005 this code works fine, but on 2008 it says I haven't created an instance of the object. I want to convert the object connString (a connection string) into a string.
'This acceses the virtual directory web.config file for connection strings
'We have to convert the object to a connection string
Dim rootWebConfig As System.Configuration.Configuration
rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/VirtualDirec")
Dim connString
As System.Configuration.ConnectionStringSettings
connString = rootWebConfig.ConnectionStrings.ConnectionStrings("ConnectString1")
Dim strConnString
As
String = connString.ToString().......
I have project in development where string operations like "Hi " + variable + ", welcome to Project" are used at many places (given example is very minor one).
One of the requirement is to convert it to string.format style.
It is very long and tedious job, where I would not like to break earlier working code due to any human error might happen while converting it.
I would like to if any Macro or VS command which I can create to handle it. Just like we mark block of code and do Extract function in Re-factor options.
I'm trying to convert a string to decimal but I get this exception:
Exception Details:
Microsoft.CSharp.RuntimeBinder.RuntimeBinderException: 'string' does not contain a definition for 'AsDecimal'
Here is the code:
decimal PriceHT = 0;
var PriceRequest= "SELECT * FROM Price_" + HttpContext.Current.Session["PriceTableId"] ;
foreach (var Price in Database.OpenFile("Base.sdf").Query(PriceRequest)){
PriceHT = PrixceHT + (Price.PT).AsDecimal(); //Price.PT returns a string
}
Code to convert english to hindi string
View 2 RepliesI have a string I need to convert back to a date. I can call .ToString("yyyyMMdd") and get the string i want. My question is how can I convert that back into a date? I'm trying something like the following with no luck.
DateTime d;
var formatInfo = new DateTimeFormatInfo {ShortDatePattern = "yyyyMMdd"};
if (DateTime.TryParse(details.DetectionTime.Date, formatInfo, DateTimeStyles.None, out d))
{
lit.Text = d.ToShortTimeString(); //would like 07/30/2010 as the text
}
I've never used DateTimeFormatInfo before if that isn't obvious. Can someone point me in the right direction. I know I could probably use substring and create a new DateTime(y, m, d) etc... I'm just wondering since c# interpreted .ToString() correctly, if it can't derive a date from the very same string it output.
I have a string:
var names = "Brian,Joe,Chris";
Is there a way to convert this to a List<string> delimited by , in one line?
I am trying to copy values in string array into a DataRow, it throws an error:
Cannot implicitly convert from string to string[]
The code:
DataRow dr = null;
ddcontent[i] = strfinalstartweek[i] + " - " + strfinalendweek[i] + "-- $" + openingbid;
// ddcontent is the string array
for (int i = 0; i < 12; i++)
{
dr.ItemArray = ddcontent[i];
ListItem item = new ListItem();
item.Text = NullHandler.NullHandlerForString(dr["OpeningBid"], string.Empty);
ddweek.Items.Add(item);
}
What do you guys think is wrong in here.. tried lot of ways trying.
i am displaying some news from rss feeds in the page. But i am stuck up in the date time conversion. I got th published datetime as pdt formated string. How can i convert to my local time. Coversion from the pdt string tot DateTime is error..
[Code]....
This second line is error and i need the result in the specified format or same format as in the published date but in local time ie IST (India Standard Time)
i want to check only if the column Active is Yes, then get into the if loop. But it gives me an error "Cannot convert from string to int" for the last condition in if. What do you guys i can do.
if (ds != null && ds.Tables != null
&& ds.Tables.Count > 0
&& ds.Tables[0].Rows.Count > 0
&& ds.Tables[0].Columns[0].ColumnName["Status"] == "Y")
{
disableloc.DataSource = ds;
disableloc.DataBind();
}
else
{
ds = null;
disableloc.DataSource = ds;
disableloc.DataBind();
The stored procedure is SELECT ML.locationname,
rtrim(ML.address) + (CASE WHEN ML.Address2 IS NOT NULL THEN ('' '' + rtrim(ML.Address2)) ELSE '''' END) + '' - ''+ ML.city + '', ''+ ML.state as address,
ML.locationid,
ML.merchantid,
case when ML.active <> ''Y'' then ''Deactive'' else ''Active'' end [Status],
(SELECT count(*) as retval
FROM merchant_statistics
WHERE type = ''merchant''
AND locationID= ML.LocationID
AND status = ''clicked'') as stat,
'' '' as button,'' '' as blank ,
dbo.GetCouponCountForLocations(@_merchantid,ML.locationID) couponCount,
MP.DomainName,
(SELECT Count(*) FROM Promotion WHERE LocationId = ML.locationid AND PostType = 1) AS jobs
FROM merchant_location ML , Merchant_Pages MP
WHERE MP.LocationID = ML.LocationID
AND ML.merchantid = @_merchantid Order By '
I have code following and i need convert string type to integer type and make to percent. But it's error "Input string was not in a correct format"
[Code]....
May i know how to convert string to int.i know using parse we can do it. instead of parsing is there any thing to convert.
View 2 RepliesI just want to know is there any Function in .Net Which Convert Number to its equivalent string.For Eg.
Number 4 should Get converted Foure or 100 as one Hundred..
I just Want to know this to avoid Set of lines of code if it is there
It is possible to convert string to boolean?If it is plz give me example
View 2 Repliesi have string like "30/03/2010 12:03:15:PM" i want to covert in date time how it possible?to convert i got this error "String was not recognized as a valid DateTime."
View 10 Replies