|
Hello everyone!
How do I convert a string containing a currency back to a decimal? I tried the following, but it gives me a System.FormatException: Input string was not in a correct format exception.
Dim dRate As Decimal
If IsNumeric(txtRate.Text) = True Then
dRate = Convert.ToDecimal(txtRate.Text)
Else
MessageBox.Show("Rate must be numeric", "Data entry error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1)
End If
The problem is the currency sign.
Thank you!
Pieter
|
|
|
|
|
If a string starts with a currency symbol, like £ or $, then you wont be able to convert it to a decimal until you remove that character.
decimal.Parse("£123.45"); <-- fails
decimal.Parse("123.45"); <-- works
|
|
|
|
|
Thank you for the reply.
I did a bit of searching on the internet, and was able to come up with the following solution:
Imports System.Globalization
mRate = Decimal.Parse(txtRate.Text, NumberStyles.Currency)
Regards,
Pieter
|
|
|
|
|
hellow to all ..
i had build a Crystal Report , i need to pick values from 2 tabels and show them , the 2 tabels are not related in keys , and to pick the values i need to use the SelectionFormula method ..
i had't have any success anyone can help or give me his opinion ?
thxx
|
|
|
|
|
Here u got some good examples with crystalreports
|
|
|
|
|
maybe you should try a different datasource. You can build your relation outside of crystal and bind the report to that data. Stored Procedure would be good for that using a join or there are always subreports. You can create relations with datasets as well and bind you report to that or even an array, limitless possibilities.
Maybe if you posted you programming environment and th erelation you are trying to creat someone ccould help more.
|
|
|
|
|
Hi to all,
I working to a query tool. The user can load a query and execute it. Some queries can contain "variables". I looked on Internet and I found they can have different aspect.
The Microsoft provider executes with no problem, queries like:
SELECT * FROM Table WHERE ID = :variable
I'm trying to execute queries like:
SELECT * FROM Table WHERE ID = ?
SELECT * FROM Table WHERE ID = &variable
SELECT * FROM Table WHERE ID = &<name="variable1" type="string">
They are named as follow:
Oracle style bindings
JDBC style bindings
Name unknown (used for example by QueryReporter)
Name unknown (used for example by QueryReporter)
To do that I've wrote a Regular Expression for each type.
"[\s]*?:[\s]*?([A-Za-z0-9^\s^<^,]*)"
"[\s]*?([\?])[\s^,^<]*?"
"[\s]*?&[\s]*?([A-Za-z0-9_^\s^<^,]*)"
"&[\s]*?<[\s]*?[nN][aA][mM][eE][\s]*?=[\s]*?""([^""\r\n]*)?""[\s]*?([tT][yY][pP][eE][\s]*?=[\s]*?""([^""\r\n]*)?""[\s]*?)?>"
My problem is this one:
I want to exclude the strings contained inside "" or ''
e.g.
I don't want to match ":this" because it's not a variable to bind
SELECT * FROM Table WHERE Column = "Hello world :this is me"
Hope I've been clear
Thanks in advance 
|
|
|
|
|
Danilo Corallo wrote: Hope I've been clear
You've not been clear at all... try asking a question for starters
|
|
|
|
|
I need a Regular Expression to match the bold part:
SELECT * FROM Table WHERE ID = ¶meter
but not this one
SELECT * FROM Table WHERE ID = "Me&You"
Thanks
|
|
|
|
|
Does anyone know the 'correct' way of adding a details element to a form? You know the sort of thing where the button shows "Options>>" and the form expands to show additional details - such as on the Windows ODBC configuration.
I know that you can resize the form and add the controls dynamically, but want to know if this is the 'normal' way of doing this. If there's a tute on here, a link to that would be great. 
|
|
|
|
|
You don't need to add controls dynamiclly...
You can simply resize the form so that if you don't want to show them they are hidden and then when you want to show details you simply make the form big enough that all the controls are shown...
--------------------------------------------------------
My development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
Hello EveryOne,
How to allow only numeric values ina textbox.if we allow characters it should pop up a message showing "need to enter numeric values".
Please HElp Regarding this,
Thanks
Nagalakshmi
|
|
|
|
|
Hi,
I don't know if this is the best way of doing it, but you could capture the textbox on change event and then loop through each char in the text field to check if it is a number or not.
So something like this:
<br />
Public Sub OnTextChange(Byval sender as Object, Byval e EventArgs) Handels T.TextChanged<br />
<br />
for each c as Char in T.Text.Chars<br />
<br />
if Not c.IsNumber Then<br />
MessageBox.Show("Bla bla bla")<br />
<br />
end if<br />
<br />
Next<br />
<br />
<br />
End Sub<br />
<br />
Hope this helps
/Johan
|
|
|
|
|
u can also do this on keypress event of text box
Private Sub txt1_KeyPress(KeyAscii As Integer)
dim strValid as string
strValid = "1234567890"
if instr(strValid , chr(keyAscii)) = 0 then
keyAscii = 0
end if
end sub
It would help u not to enter any character other than numeric values
Noshaba
|
|
|
|
|
Rather than annoy the user with a popup message which theyneed to discard every time they type an incorrect character, you should really restrict the characters that can be entered in the first place.
There are plenty of articles/posts on this subject here at CP if you search.
|
|
|
|
|
I built a little function:
function CashVal (byRef Intext as object, byRef ErrInd as boolean) as double
1. Check Intext to be sure it's not nothing
2. Check Intext to be sure it's not null
3. Check Intext to be sure it's numeric (and in my case, > 0...)
4. Return CDbl(Intext) and an appropriate ErrInd.
I invoke this (x = CashVal(textboxname.text,Error_Indicator) )when the "leave" event is fired, so the user can type anything, and it's evaluated as a whole. The event handler checks to see if there was an error. If not, it sets the text property of the text box to format (x, "currency"). If there's an error, obviously, it can react appropriately.
|
|
|
|
|
http://www.cambiaresearch.com/cambia3/snippets/javascript/browser/allownumbersonly.aspx
|
|
|
|
|
One of easy ways....
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress<br />
If (AscW(e.KeyChar) < 48 Or AscW(e.KeyChar) > 57) And Not e.KeyChar = Chr(Keys.Back) Then<br />
e.KeyChar = Nothing<br />
End If<br />
End Sub
Regards,
Chatura Dilan
|
|
|
|
|
hellow to all ..
i wanna count in crystal reports field that have boolen values , but i wanna count them when they are true ..
how can i do this ?
|
|
|
|
|
I am useing DataGrid
VB.NET ,WINFORMS
I want to place Buttons/Hyperlink for a entire Coloum when grid is displyed
i had done some coding but, the but is displyed in ACTIVE Cell only,
but i want it to be disply by default in entire column
Any Advice/Suggestions.../links
Thanks in Advance
-- modified at 2:37 Wednesday 12th April, 2006
|
|
|
|
|
Friends the best Reference for my question,
if any is in req of this type of solution, pls do vist this links
its very simply & easy then wht v actually guess
http://msdn.microsoft.com/smartclient/default.aspx?pull=/library/en-us/dnwinforms/html/datagridcolumnstyle1
http://msdn.microsoft.com/smartclient/default.aspx?pull=/library/en-us/dnwinforms/html/datagridcolumnstyle2.asp
With Best Regrads
Electron
|
|
|
|
|
Friends the best Reference for my question Regrading datagrid,
if any is in req of this type of solution, pls do vist this links
its very simply & easy then wht v actually guess
http://msdn.microsoft.com/smartclient/default.aspx?pull=/library/en-us/dnwinforms/html/datagridcolumnstyle1
http://msdn.microsoft.com/smartclient/default.aspx?pull=/library/en-us/dnwinforms/html/datagridcolumnstyle2.asp
With Best Regrads
Electron
|
|
|
|
|
Dear All...
Please help about it.
I have 1 PS2 keyboard and 2 USB Keyboard Connection in my computer.
I want to write a samll Program that is Checking keyboardID.
When user press key , this program can display Keyboard..
Zawlat
|
|
|
|
|
zawlat wrote: I want to write a samll Program that is Checking keyboardID.
Too bad the system doesn't differentiate between them. When a key is pressed, there is nothing in the message to say which keyboard it came from. You'd have to write your own filter driver that sits just above the keyboard drivers to expose something like this. You can't do this in Managed Code. This is the domain of C++ and the Windows Device Driver Development Kit.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
hi friends
i am working on ms access front end, i have Edit form which cotains a combo box this combo box is bound with a table named Department, this combo box have names of departments which have entered in the table, i want at run time when i select a department name from this combo box other information related to this department will be display in respective text boxes of the form.
i am using the following code it gives a etrror there
Private Sub cmbSectorName_Change()
Dim rst As ADODB.Recordset
Dim ch As String
ch = cmbSectorName.Value
Set rst = New ADODB.Recordset
rst.CursorLocation = adUseClient
rst.Open "Select Description From tbl_Sectors where Name=ch", CurrentProject.Connection, adadOpenKeyset, adLockOptimistic
txtDeptDescr.Text = rst.Fields(0).Value
rst.Update
rst.Close
Set rst = Nothing
MsgBox "Data Has Shown Successfully"
End Sub
when i change selected name of the combo box it gives error "No Value given for one or more parameter " and get focus to this line fo code
rst.Open "Select Description From tbl_Sectors where Name=ch", CurrentProject.Connection, adadOpenKeyset, adLockOptimistic
friends kindly can soem help me
and second this it that after this i want to allow user to change soem information of this selefcted department and then on click event of Edit button it will updeated in data base
i need ur help regarding these two problems may u guide me
regards
Farooq Azam
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
