[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'm having problem getting the syntax right for an SQL statement for a Progress database. I have the column "Resource" which is a reserved word and according to the Openedge SQL Reference I can only use reserved words if I delimit them with double quotation marks.
So how do I write this line...
Dim comm As New OdbcCommand("SELECT Resource FROM PUB.ActOper WHERE CreDate > TO_DATE ('05/24/2010')", conn)
...with double quotes around Resource? I've tried a bunch of different combinations but I get "Expression expected" or "valid continuation expected" or something similar.
im 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 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 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.
I have written this narly Select Statement for my site, this is for the data in my control panel, I did it this way to have only one access instead of six I currently have, but I keep gettin a syntax error near'customer_data'
I have tried several things, but I still get the error, could someone check for me please
[Code]....
As you can see I have aliased customer_data as CD
I need to enter amount in textbox. actually i will enter 12 in textbox then after that i will press tab button it will need to convert 12.00 not only that along that i need double(13,2) only in textbox.It never accept more that (13,2).
Note :1222222222222.00 or 1223333333333.22 like that i need i mean not exceed (13,2).I will accept less that that also like 12.22.
How to disallow use of double quotes " in a textbox
View 5 RepliesI am formatting textbox currency values as follows:
this.MyTextbox.text = String.Format("{0:c}", dblTotalNrcIrapContributionAmount);
I need to copy the values from a textboxes text property into a nullable double, currently I have:
//test for empty string - if yes set dblMyAmount to null,
// else set value to this.MyTextbox.Text value
Nullable <double> dblMyAmount = ((this.MyTextbox.Text +
"").Trim() ==
"") ? (Nullable<double>)null :
Convert.ToDouble(this.MyTextbox.Text);
which is not working - the error message is "Input string was not in a correct format."
I am writing value to a textbox from handler(ashx) file. But the problem is that when the value contains double quote or single quote the textbox only shows the value before that quote and omits the the string after that quote.
For eg Value is: Hi "there
The textbox shows: Hi
Right now I have an error if f.ParentID is null:
DataSet1.TreeItemRow[]
TreeItemRows = (from f
in tidt
where (f.ParentID == TreeItemId)
select f).ToArray();
I must continue if f.ParentID is null, I don't want to include null fileds in the array. What is the right syntax for that is linq sql?
Using linq to entities i am connecting to a database, the database has tables in it that has payments that have a multi to multi relationship with jobs. This is acheived via an allocs table. I want a list box with all the jobs that has a column called due price which takes all of the allocations of payments for this job and takes that away from the job price. However, using the below linq to entities statement. The problem is that if the job has no allocations it returns null and therefore the due payment is empty. What i really want is for the due payment to be the job price if there are no allocations however, i cannot think of a way around this.
var jobs = from j in data.jobs
where j.property.customer.id == customerid
&& j.completed != null
select new
{
j.id,
j.price,
dueprice = j.price - ( from a in data.allocs
where a.job.id == j.id
select a.amount ).Sum(),
lineone = j.property.lineone,
postcode = j.property.postcode,
jobtype = j.jobtype.name,
j.completed
};
In my application I have panel which has 5 textboxes. I've written several functions for checking each of textbox if the entered value is ok (number, is this number in database, etc.). If error occurrs textbox which caused it has different color of background.
However I wanted to write (add) function which will check if one of the textboxes has the same value as other. The problem is that function is checking blank textboxes, although it shouldn't - I wrote if statement which allows checking only non-blank textboxes but it doesn't work.
I currently do something like...
[Code]....
Now I know this works.. but what is the right way to have this? I don't want to be checking something twice instead of just having it written out once.
It's Convert mixed letter to Number worked. I use sametimes russian letter с and е program must check if е then convert to 5 if с then convert to 3.
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 have one asp.net Textbox,I need to check If statment in aspx.cs files is that textbox contain for example: 200 (or) - 200...based on this i need to execute query...
View 5 RepliesRequirment is: while enterening the value you should know that this values is already we have used in data base for that textbox field.Please give code in .aspx and .aspx.cs with database if any
View 4 RepliesIf in textbox the default textbox value id 1,2,3,4,5,6 ...... upto 55 then the following checkboxes would be checked according to the text display in text box. if textbox1.text =1,2,3 then in my webform checkbox1, checkbox2, checkbox3 would be checked ... on page load event. how to do this?
View 2 RepliesI have 5 textboxes and 1 button. I want when i fill 5 TextBoxes any informations , then i click that button , that button will be disabled . And then , if i focus to that 5 textboxes and fix informations again , that button is enabled .
- That mean i have to focus to that textboxes , so i program it like this :
if(textBox1.focus())
{
button1.Enable=true;
}
- But nothing happen , so how to solve this problem ??? .
- I searched Google , it tell me "using : this.Activecontrol is the way easiest and shortest" . So , How to i have to do ???
In .net streams are by default encoded in utf-8. so what i want to do is to simply read the text in a textbox in which i paste the russian characters and then convert them to ascii. but when i debug the code then in my resulting string ? appears. how i can convert the string into its ascii equivalent. my code is given below
string inputString = txtName.Text;
ASCIIEncoding ascii = new ASCIIEncoding();
Encoding encoder = ASCIIEncoding.GetEncoding("us-ascii", new EncoderReplacementFallback(string.Empty), new DecoderExceptionFallback());
byte[] bAsciiString = encoder.GetBytes(inputString);
string cleanString = ascii.GetString(bAsciiString);
I have the One string that contains id of the TextBox for Example..
string test="txtDegree" + i;
I want Convert the sting value into TextBox to show the Data. For ex. at runtime time i want to do show data in txtDegree1, txtDegree2 & so on.
last time i did one Desktop application using c# in this application i used Baraha language converter for different indian language. when user enter some text in TextBox its automatically convert to my language.. the same thing i want to apply in web application when user enter some text in texbox i should be convert to (tamil,hindi,marathi,kanada) any of one languageif you have some idea or if you know some use full link for this please forward me
View 2 Repliesi have a textbox and a button.when the page loads, the textbox text read "hello"now when a user changes the text and then presses the button which causes a postback, how can i check if the user changed the value of the textbox or not?
View 2 Replies