|
I want to read excel file in asp.net using Vb.net and also want to write and excel file from the database values. Data can be both numeric and alphabetic.
Thanks in advance
Do good and have good.
|
|
|
|
|
Hi,
Use the Excel Object.It'll help you to read the Excel file and create the Excel file from the database values.
Thanks and Regards
Ganesan.S
Software Engineer
|
|
|
|
|
|
what can e the regular expression string , in order to validate the textbox , to have either whole values or fractional values.
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
*sigh* you just lurch from one question to another, don't you ? I mean, you never actually try to do anything for yourself.
The best way to do this is not a regex, but to validate each character as it's entered ( as all the examples you find on the web will show you ). You only accept the . if the string does not contain one. You obviously accept control characters and numbers, always.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Please do not provide your email address/id. It may be miss use.
|
|
|
|
|
which type value u want to validate or which type value u want restrict.
Piyush Vardhan Singh
|
|
|
|
|
var = "[0-9]+$"
this is working fine for the numeric , if i insert the . then it does not allow.Proble is user can insert the . or not, i mean it can have fractional values ot whole values.currently , my expression is working for the whole values only.Please help.
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
Sonia Gupta wrote: var = "[0-9]+$"
var = "[0-9\.]+$" ?
|
|
|
|
|
But this will also match 12.......3
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Yes it will. need to alter it a bit. I don't have regexbuddy installed right now. It's tough to write directly.
|
|
|
|
|
ur string is not working for 4c1.24
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
Now you know how your boss feels.....
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Sonia Gupta wrote: 4c1
4c1 ? is it a number ? it won't match
|
|
|
|
|
i was testing a fractional value with the said expression.
it got faied when i used this value.
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
4c1.24 u want to validate this type of string
Piyush Vardhan Singh
|
|
|
|
|
[0-9]+[.]?[0-9]*
+ means match at least one, ? means match one only and * means match as many as are there, including none. You'd know all this, if you were not scared to use google, or read books.
And, a regex is still not the best way to go, it's much easier to just validate the keys as they are pressed.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Christian Graus wrote: [0-9]+[.]?[0-9]*
I doubt, will it allow normal digits like 1,2,3. I guess this allows only numbers with decimal part ?
Christian Graus wrote: And, a regex is still not the best way to go
AFAIK, Regex is powerful and always recommended. Is it ? Then why it's a bad way to go ?
|
|
|
|
|
N a v a n e e t h wrote: I doubt, will it allow normal digits like 1,2,3.
No, it allows what she wants. A single floating point number. It will not allow .5, it would require 0.5. That's it's only flaw as far as I can see.
N a v a n e e t h wrote: Then why it's a bad way to go ?
Because she's using a sledgehammer to push in a pin. Checking as you go via checking each key press is more lightweight and will work just as well. Who knows what sort of browser her code will run on ? It would not even surprise me for some mobile browsers to have some basic JS support but not regex.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Christian Graus wrote: Who knows what sort of browser her code will run on
LOL then it's fine.
|
|
|
|
|
string is not working for 12d
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
you probably need to reinstate the $ at the end, and I believe it's ^ at the start, so that you are asking to match the entire string.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
[0-9a-zA-Z.]+$
i think u want this type of validation.
Piyush Vardhan Singh
|
|
|
|
|
i don;t want alpha-numeric.only numeric or float values are permitted.
Please help.
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|
|
Sonia Gupta wrote: i don;t want alpha-numeric.only numeric or float values are permitted.
Please help.
Use the pattern provided by Christian Graus. It will work.
|
|
|
|