C# Discussion Boards - CodeProject

ansriharsha8-Jul-09 23:37

8-Jul-09 23:37

Hi ,

i want to specify the maximum number of digits for numeric part and the Decimal part in a text box.

i tried specifying precision and maxlength of the text box but then it if we input the max length then the precesion cannot be inputted and it gets resetted to the maxamount which should not be possible.

like if Maxlength=8

precsion = 2

input required:123456.90 possible

input required : 12345678.89 which is not possible

so is there any way we could specify the format of the numeric part and as well the decimal part. which would restrict for only that particular input format.

like : dddddddd.dd

thanks in advance....

cheers,

sriharsha

Re: Numeric Format problem

Pete O'Hanlon8-Jul-09 23:43

Pete O'Hanlon

8-Jul-09 23:43

Use a masked edit box.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: Numeric Format problem

ansriharsha9-Jul-09 1:29

ansriharsha

9-Jul-09 1:29

Hi,
i have tried using masekedit ,

<ajaxtoolkit:maskededitextender id="MaskedEditExtender1" runat="server" acceptnegative="Left" displaymoney="None" mask="9999999.99" masktype="None" messagevalidatortip="true" oninvalidcssclass="MaskedEditError" targetcontrolid="TextBox4" clearmaskonlostfocus="false">

<ajaxtoolkit:maskededitvalidator id="MaskedEditValidator1" runat="server" controlextender="MaskedEditExtender2" controltovalidate="TextBox4" cssclass="InputFieldRed" display="Dynamic"
invalidvaluemessage="Invalid " isvalidempty="false" tooltipmessage="" validationgroup="Search">
;

when for example

input is 12345678.90 no problem
but when

input is 11.11 > it changes to 1111 when i click it again.
and when it is something like

input is 11 .11 it changes to 1111 when i click it again.

is there any way it takes the input in a normal way and also restrict the format required for the number.

thanks and regards,
sriharsha

Re: Numeric Format problem

Eddy Vluggen9-Jul-09 1:47

Eddy Vluggen

9-Jul-09 1:47

Verify whether the decimal-separator is set to a dot - if it thinks that it's a thousand-separator, it will simply remove it from the input Smile | :)

"please help in this regard. give the visual basic code for this as soon possible."

Re: Numeric Format problem

ansriharsha9-Jul-09 2:40

ansriharsha

9-Jul-09 2:40

hi,
i even tried specifying
property Filtered="." of maskededit

but it does not work still the same problem.

what can be done to avoid it ...

thanks ans regards,
sriharsha

Re: Numeric Format problem

Eddy Vluggen9-Jul-09 2:51

Eddy Vluggen

9-Jul-09 2:51

"Filtered"? Didn't you mean Mask[^]?

"please help in this regard. give the visual basic code for this as soon possible."

Re: Numeric Format problem

ansriharsha9-Jul-09 3:47

ansriharsha

9-Jul-09 3:47

Hi,
No

<ajaxtoolkit:maskededitextender id="MaskedEditExtender1" runat="server" acceptnegative="Left" displaymoney="None" mask="9999999.99" masktype="None" messagevalidatortip="true" oninvalidcssclass="MaskedEditError" targetcontrolid="TextBox4" clearmaskonlostfocus="false" filtered=".">

Filtered="." property of maskededitexteneder .

but not working.

where else can we set the decimal...?

thanks and regards,
sriharsha

Re: Numeric Format problem

Eddy Vluggen9-Jul-09 3:57

Eddy Vluggen

9-Jul-09 3:57

In the configuration panel, under "Regional Settings" - but that applies only to the culture of the local computer.

The extender is part of the AJAX-framework, and the control is unknown to me. I suggest asking this question in the ASP.NET forum Smile | :)

"please help in this regard. give the visual basic code for this as soon possible."

Re: Numeric Format problem

ansriharsha9-Jul-09 4:33

ansriharsha

9-Jul-09 4:33

hi,
is there any way through c# we could fix the format or maximum length for numeric part and decimal part.

like

number format: (8,2) only.

thanks
sriharsha

Re: Numeric Format problem

Eddy Vluggen9-Jul-09 6:33

Eddy Vluggen

9-Jul-09 6:33

Information on formatting a string can be found here[^]. That's for display - it won't stop the user from entering three decimals.

You can use the MaskedTextBox.Mask[^] property to get more control on the input.

Good luck Smile | :)

"please help in this regard. give the visual basic code for this as soon possible."

Re: Numeric Format problem

ansriharsha17-Jul-09 0:50

ansriharsha

17-Jul-09 0:50

Hi ,

I used Regularexpression and its working fine.

as:

<asp:regularexpressionvalidator id="regexpName" runat="server"
errormessage="This expression does not validate."
controltovalidate="TextBox5"
validationexpression="^\d{1,8}(\.\d{1,2})?$" enableviewstate="true">;

in
controltovalidate : speicfy the textbox to validate
ValidationExpression: which validates the expression in the format (8,2)
otherwise gives error.

Thanks for all suggestions.

sriharsha

Please Help...

mjawadkhatri8-Jul-09 23:00

mjawadkhatri

8-Jul-09 23:00

Hi Please Help me i get this error when i connect to database

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server"

i use this coding

" SqlConnection con;
SqlCommand cmd;
SqlDataReader dr;

private void login_Click(object sender, EventArgs e)
{
con = new SqlConnection("integrated security = true;Database=orcl8i;Password=creative;User ID=itehad");
cmd = new SqlCommand();
cmd.Connection = con;
cmd.Connection.Open();
cmd.CommandText = "Select * from users";
dr = cmd.ExecuteReader();
while (dr.Read())
{
if (usr.Text == dr["userid"].ToString()) && pass.Text == dr["password"].ToString)
{
MessageBox.Show("User Login", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
else

MessageBox.Show("Login Fail")

Re: Please Help...

Pete O'Hanlon8-Jul-09 23:16

Pete O'Hanlon

8-Jul-09 23:16

I assume that you have a direct link to Code Project on your desktop, and your browser has had the address bar physically torn off it and thrown away in the trash. After all, a quick search returns lots and lots of hits[^] for this. I know that it means you've got some reading to do, but you wouldn't want us to hold your hand for you, now would you?

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: Please Help...

Luc Pattyn9-Jul-09 9:42

Luc Pattyn

9-Jul-09 9:42

Pete O'Hanlon wrote:
you wouldn't want us to hold your hand for you, now would you?

is that a trick question?

Unsure | :~

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: Please Help...

Blue_Boy8-Jul-09 23:26

Blue_Boy

8-Jul-09 23:26

Check if your connectionstring with DB is correct.

check this[^]

I Love T-SQL www.aktualiteti.com
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: Please Help...

mjawadkhatri9-Jul-09 0:00

mjawadkhatri

9-Jul-09 0:00

Can't understand let me explain please Sigh | :sigh:

Re: Please Help...

J4amieC9-Jul-09 0:47

J4amieC

9-Jul-09 0:47

I might be mistaken, but is:

mjawadkhatri wrote:
integrated security = true;Database=orcl8i;

really a SQL Server database?

Re: Please Help...

mjawadkhatri9-Jul-09 0:54

mjawadkhatri

9-Jul-09 0:54

no is a oracle database

Re: Please Help...

Pete O'Hanlon9-Jul-09 1:01

Pete O'Hanlon

9-Jul-09 1:01

Then, supplying a SQL Server connection string isn't going to help you. Oracle connection strings typically look like:

Data Source=oracledb;User ID=userid;Password=password;Min Pool Size=2;Connection Lifetime=60;Connection Timeout=60; Incr Pool Size=5; Decr Pool Size=2

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: Please Help...

mjawadkhatri9-Jul-09 1:21

mjawadkhatri

9-Jul-09 1:21

Thanks For Given b great response
bt when i use your given code i get this Error
Keyword not supported: 'incr pool size'
please help me Pete O'Hanlon.

Re: Please Help...

Pete O'Hanlon9-Jul-09 1:25

Pete O'Hanlon

9-Jul-09 1:25

Where to start? First of all, you are connecting to Oracle but you are using Sql Server classes in your code. You need to use the appropriate Oracle drivers, rather than SQL Server, and use the Oracle classes such as OracleConnection. Download, and have a look at, the ODP.NET providers from Oracle.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Re: Please Help...

mjawadkhatri9-Jul-09 1:50

mjawadkhatri

9-Jul-09 1:50

okk.
thank u so much sir.

Help Please Email Text Box

Danie de Kock8-Jul-09 22:21

Danie de Kock

8-Jul-09 22:21

Hi I'm looking for a textbox/richtextbox/something that can open a email body.
The Email can be in html/txt/office format.
Must also be editable. Example: The Textbox in outlook
In C#

Re: Help Please Email Text Box

Danie de Kock9-Jul-09 0:18

Danie de Kock

9-Jul-09 0:18

found it

Re: Help Please Email Text Box

K03069-Jul-09 1:56

K0306

9-Jul-09 1:56

If you found the solution for your problem, then Post the solution here, it will help to someone.

Regards,
Karthik K...

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.