i wanna convert char to double type and convert it to date.char->double then double -> date type.I have a whole string and i trim it into 3 parts. In my item(2) is a UNIX Timestamp i'm trying to convert it into date type.
[Code]....
I am using SQL Server 2008 Web Edition and it seems my SQL queries are automagically having the double quotes replaced with ' + CHAR(34) + '. I am trying to pin down why this is happening, I am using Delphi with ASP.NET and using the ADO.NET object for the SQL.
Has anyone come across this before?
Let's say I am pulling data from SQL using a function that returns one field - date. I can see that in my model code for a getter, setter, and other things are set for DateTime. What happens if I go into the function and convert selection of my date field into char(10)?
View 6 RepliesI've been trying to insert new values while I create a new user with a createuserwizard, but I've been getting this error over and over again:
"insufficient result space to convert uniqueidentifier value to char"
The code that does it is the following:
[Code]....
But when I debug, the error is thrown before reaching the previous code, so I suppose the error is in the SqlDataSource, look:
<asp:SqlDataSource ID="InsertExtraInfo" runat="server" ConnectionString="<%$ ConnectionStrings:DefaultConnection %>"
InsertCommand="INSERT INTO [User_Personal] ([UserId], [Gender], [ToGender], [StateName], [CityName],
[code]...
i'm a new developer...i have been given a project to generate a user name of 6 chars. the user name has 1st 2 char the 1st 2 letters of the name and remaining 4 char as any random numbers. alone with that i have to send a random password with it..
View 2 Repliesim getting a value from the database. it came out an error saying "Conversion from DBNULL to Double is not Valid." anyone,
[code]...
im getting a value from the database. it came out an error saying "Conversion from DBNULL to Double is not Valid."
Public Function Total() As Double
Dim Total As Double
Dim strConn As String
strConn = ConfigurationManager.ConnectionStrings("***").ToString
[Code]....
i have a strange error creaping into my web app but am unsure as to how to fix it. When i run this code on my debug workstation it works fine but when i transfer it to my server things seam to go wrong.
dev station (windows 7) + VS2010
regional and language settings all set to uk
server (windows 2008r2)
regional and language settings all set to uk
What seams to be happening is that when converting a string to a double it works correctly on the dev environment but moves the decimal place to the end on the server.
example code(vb)
dim lat as string = "52.983829"
dim long as string = "-0.036500"
dim latint as double = lat
dim longint as double = long
now on the dev server the value of latint is 52.983829 as you might expect but on when published to the server it becomes 52983829.0 the same with longint on the dev staion it is -0.036500 but on the server it becomes -36500.0 i get equally confusing problems if i try to change it to an integer instead.
[Code]....
I have one gridview footer template textbox and asp.net textbox. Here i need to check bothe textbox value are equal in if statement. How to convert both textbox in double and use in if statement to check.
i designed my gridview like below
<ItemTemplate>
<table>
<tr
class="searchtext">
[Code]....
I m binding a datalist with the dataset through stored procedure which has a column 'Photo' but it is giving me this error
View 1 RepliesI'm using linq to sql,everything seems to be working fine except one thing,I'm showing any mapped float fields from my db tables as "Double?" instead of "Double", and when binding to a datagrid, any of those "Double?"fields don't show.If I iterate through the items and spit out the property,the float value is indeed there and properly returned.
View 3 RepliesI am having a problem about my gridview when it binds to an accessdatasource.
The error appears:
"DataBinding: 'System.Char' does not contain a property with the name 'Firstname'."
Here's my gridview:
[Code]....
Here's my code behind:
[Code]....
The error occurs when the selected index of the DDL is 1 and I have to bind it in an accessdatasource. First condition is working fine where I will check a value and put all items that matched the date criteria in a data table and then bind gridview in the data table.
The error is just when I bind my gridview in the accessdatasource.
AccessDataSource1.SelectCommand = "Select Firstname,Middlename,Lastname,Jobseeker.IdNo,SchDate,Time,Venue,JobPosting.JobCode,JobTitle from JobPosting INNER JOIN (Jobseeker INNER JOIN ApplicationProgress ON Jobseeker.IdNo = ApplicationProgress.IdNo) ON JobPosting.JobCode
= ApplicationProgress.JobCode where PostingHr = " & Session("Id") & " and SchDate = '" & Date.Today.ToString("dd - MMM - yyyy") & "' "
GridView1.DataSource = "AccessDataSource1"
GridView1.DataBind()
it is really annoying that I am keep getting these error. what is that. we started to get this afte we updatet the net framawork for security vulnaribility. here is the error we keep getting. but not everytime;
System.FormatException: Invalid length for a Base-64 char array.
Generated: Thu, 07 Oct 2010 04:05:16 GMT
System.Web.HttpException: The state information is invalid for this page and might be corrupted. ---> System.Web.UI.ViewStateException: Invalid viewstate.
[Code]....
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
View 8 Repliesi want when user click on submit button then a div layer will be generated over the textbox whose height and width will be just the same as textbox and in this way textbox will be blocked for entering something. i want to do it by javascript. in this scenario other textbox will not be blocked.
View 3 Repliesi am trying to implement this vb codes to my gridview for showing fixed char and with tooltip.My NewsHeader column property in sql is Text. How can I correct this error?
[Code]....
i have a page for search.and there is abutton when user click on it.result get in dataset.
[Code]....
i have repeater in itemtemplate of repeater i put table and there is lable that i want show hotelname on it.but it has error.my code is:
[Code]....
the error is:DataBinding: 'System.Char' does not contain a property with the name 'hotelname'.
when I add "%" character to the mvc url prject I get bad request from server , how to let such character to be allowed in the url I want this to work if possible/Home/%2fContentFiles%2fImages%2f2.jpg/194/184/w if I remove "%" it work fine
View 4 RepliesI have a list XML elements that I need to compare to chars in an array. Some of the XML elements start with uppercase characters and some dont.
So I need to convert the XML elements to lowercase to compare them against "alphabet".
I'm doing this by converting the XML element to a string. Then setting that to lowercase. Then converting that to a char. Then comparing that to each char in "alphabet".
Is there a better way to get the XML into lowercase? IE without the two conversions
[Code]....
how to change
XXX@YYY.ZZZ into XXX_YYY_ZZZ
One way i know is to use the string.replace(char, char) method,
but i want to replace "@" & "." The above method replaces just one char.
one more case is what if i have XX.X@YYY.ZZZ...
i still want the output to look like XX.X_YYY_ZZZ
is any meaning of # char in page url... u can see this in below [URL] see in last #tile=outlook...
View 12 RepliesWhen I try to run the following code it always spits out the hex representation, not the integer representation. Most of the examples I found on MSDN said this should work. What am I missing?
var stringBuilder = new StringBuilder("8");
int j = 0;
foreach (char item in stringBuilder.ToString())
{
j = Convert.ToInt32(item); //returns 38, need return to be 56
}
edit I should have made clear that I know the difference it's returning the hex value. I'm outputting the value to a file, and in that file, it still shows the hex value, not the integer, so I don't think it has anything to do with the debugging environment. edit2 Looks like a PEBKAC problem. Looked at the code that was writing to the file, and it was using a .toString("X") method, changing it to a Hex value. The fact that it was hex in my debug environment was what confused me.
I was looking for how to make a password char in console. I solved it it with this [URL] ....
But is there anyway to read the password and if its GOOD, it change the pass tthe word "RIGHT Password" And if its wrong make it "Bad password", then make a new line with again. "Enter password"....
I use asp.net + MVC1.0 and in a webpage I have several forms, within each forms I have called the following function
AntiForgeryToken() to generate a hidden value, and in Controller function I have a validate attribute.
When I use JMeter and capture the token using regular expression then post the token with my form to server, I found it throw such a exception:
<html>