i am using one text box to enter phone number,bt here is some problem. if user enters other than Numeric ,the text box should show the error. how can i do that?
View 10 Replies
I have a gridview control that has two bound fields. I want to restrict the user's to enter only numeric values in the second bound column. I went into the properties of the gridview control. Selected "Columns" and clicked on collection. The fields showed up.
I selected the field and clicked on the properties. I found DataFormatString property. can I restrict by making changes to this property?
Me with C# asp.net, how can I validate a text box such that it should accept only numeric values and -
View 6 Repliesi have set the type of a column in a table numeric(6,2) but when i insert a value above 9999,99 i get the error
"Arithmetic overflow error converting numeric to data type numeric."
Do you know whats wrong??
ofc thats all through visual studio for an asp site thats why im posting here
i have a string of format ( 3.7 cm - 5.4 cm ) now i want to get the to numbers in the string into two variables for comparision
View 8 RepliesHow to restrict user to not enter any characters othar than numeric values i have this textbox
<asp:TextBox ID="txtToPage" SkinID="textBoxSmall" runat="server" Style="width: 30px;"></asp:TextBox>
add the numeric values in two textboxes(textbox1+textbox2)
and when the button event takes place
the value(textbox1+textbox2) has to be displayed in textbox3.
can some in send me the code'for that .
i tried to convert string to int
but its trowing some kind of errror
I want to validate a textbox that only a numeric currency value can be put into it, for example 0.00. I thought the following code was correct but it doesnt seem to wrk, its causing an error on my page and when I remove it the page is fine, it doesn't actually give exact details of the error on the page just says "syntax error" in the browser that is all.
[Code]....
In this query below I need the total of the 'amount' field.
SELECT
[Amount]
FROM
deals_DealBucks
I need to create a textbox that accepts only numeric values. If the user presses a string in the textbox an alert message should be displayed.The user should not be able to type other characters Users should be displayed a instant message when character other than numeric is pressed
View 3 RepliesI need to make sure a user can only enter numeric values for my Invoice Amount Textbox. It is a decimal field in my database.
I came across the MaskedEditExtender. It seemed like the solution for the problem. However, say I want to enter an amount of R50.00
The mask is set to 9,999,999.99.
When the textbox looses focus the amount becoomes 5,000,000.99.
Is there a better way that I can achieve this??
Code:
<cc1:MaskedEditExtender ID="InvoiceAmountMaskedEditExtender" TargetControlID="txtInvoiceAmount"
Mask="9,999,999.99" MessageValidatorTip="true" MaskType="Number" AcceptNegative="Left"
DisplayMoney="Left" ErrorTooltipEnabled="true" runat="server">
</cc1:MaskedEditExtender>
For efficiency's sake I've created a number of stored procedures to run against an SQL table. Which procedure runs depends upon the checkboxlist choices a user makes before clicking a button. The checkboxlist looks something like this:
<asp:CheckBoxList AutoPostBack="True" runat="server">
<asp:ListItem Enabled="True" Value="1">Item 1</asp:ListItem>
<asp:ListItem Value="10"> Item 2</asp:ListItem>
What I can't figure out is how to loop through the checkboxes in the Button1_Click event in the .cs code behind page to add up the values of the selected items. (The value of an unclicked box being 0.) Converted to a string, the totaled value is then appended to a stored procedure name (MyPROC) for entry into the SQL statement. In other words, if the user clicks just Item 1, then the Button1_Click event would produce a stored procedure name of MyPROC1, insert it into the statement, and fire off the query; if Item 1 and Item 3 are selected, then MyPROC101 would be called.
My second question is: how do I place the concatenated string into the SQL statement?
This might all seem a bit unorthodox, but given the number of variables going into statement, it seems to this newbie the best approach.
I have a EmpID it has string datatype and values are numeric how to sort this one?
View 5 RepliesI want to achieve 30 numeric 2 decimal point text box. how can I achive this
View 4 RepliesFirst of all im new to asp.net and am in the process of learning it.
Heres my problem, i am receiving this error when submitting the form: "Arithmetic overflow error converting numeric to data type numeric"
And it halts at command.ExecuteNonQuery();
Input form:
[Code]....
Code Behind:
[Code]....
Stored Procedure:
[Code]....
How would I retreive the following numeric id value from a xml response, to a dropdownlistbox?
[Code]....
The following does not work for newContactID
var xmlResponse = proxy.ProcessClientAction(xmlRequest);var parsedXmlResopnse = XElement.Parse(xmlResponse);
I would like to have the ContactRecID's value stored in the variable newContactID based on the selection of the user. So if the user selects the the person "Sam" then 4033 should be stored in newContactId.
[Code]....
I have a textbox with numeric updown extender.I want the text of the textbox.I have written code in code file is
String a=txtHour.Text
// Source FIle COde
<asp:TextBox ID="txtHour" runat="server" ReadOnly="True" Width="45"
Style="text-align:center" Height="20px">
</asp:TextBox>
<cc1:NumericUpDownExtender ID="NumericUpDownExtenderHr" runat="server"
Enabled="True"
Minimum="00" Maximum="23"
TargetControlID="txtHour" Width="40">
</cc1:NumericUpDownExtender>
Is it possible to display a list of descriptive phrases (say pulled from a lookup table in a database) but store a code in another table? I'm a beginner at ASP.NET but have some experience with SQL Server. If so, how can I do it?
View 9 RepliesI'm looking for third party components that support the following requirements:
1) Ability to enter information into a numeric (preferably spin button enabled) text box as fractions.
2) Support for conversion between fractions and decimal.
3) Support for conversion between metric and imperial units of measurement.
I have generated dynamic text boxes for each table row there are 6 text boxes
1. For the first two text boxes the values given by the user should be in valid range(this range comes from the database).User is allowed to enter the value within that specified values only. How to achieve this? I have taken drop down lists but if the values in drop down increases selecting required value is tedious to the user.. (if it is having 1000 values) and while I am retrieving the values I have written query such as Null values ignored. But I am getting NULL values in the dropdown here is the code what I have written,
(Database is Oracle)
If
Not (OledbCmd.Equals(String.Empty)
Or OledbCmd
Is
Nothing)
Then
OledbDA.SelectCommand = OledbCmd
OledbDA.Fill(ds, "textDB")
dt = ds.Tables("testDb") If
(dt.Rows.Count > 0) Then
ddlist.DataSource = dt If UCase(s) =
"NUMBER"
Then
ddlist.DataValueField = "num"
ElseIf UCase(s) =
"NAME"
Then
ddlist.DataValueField ="name"
End If
ddlist.DataBind()
ddlist.Items.Insert(0,
"Select")
ddlist.SelectedIndex = 0 Else
ddlist.Items.Insert(0,"Norecords")
End If
End
If
2. In the rows generated when user presses functional key F3 then the values of the above row(previous row) have to be copied in present row. similarly for F4 column copying. This I achieved through the Java script. But I have many forms requirement is same. where as text boxes id differ. how can I generalize the One function to work for all forms. I wrote as like this.
document.getElementById("No"+ cnt).value = document.getElementById("No" + (cnt-1)).value;
document.getElementById("Name"+cnt).value = document.getElementById("Name" + (cnt-1)).value;
For all the 6 text boxes.where as for column copying I wrote as
document.getElementById(id + cnt).value = document.getElementById(id + (cnt-1)).value;
here id is the text box id Which I am passing.
I am getting int values from the stored procedure. But when i bind this datasource with the gridview i am seeing the values being converted into float. i am using Text='<% # Bind("Quantity") %' I wanna that to be displayed as int, with out zero'seg: let the value be 233, when i bind that its getting displayed as 233.00
View 1 Replieshow to type the user in textbox in arabic text without changing the language in their pc?! using c# .net
View 3 RepliesI need to validate the text box at server side by using regular exp which should accept 1 or 2 or 3 or 4 or 5 digits numbers .Need to restrict decimal part.
Ex: 1 or 23 or 455 or 5643 or 45667 --Should accept.
1.3, .2, 33.3 , 444.55 ,5555.99 -- should not accept.
I have a detailsVeiw bounded with the sqldatasource.I want to restirct user to update all data in text boxes.
Or in words if user click Edit then it is required to show some text boxes to update and other should be read only.
How to do this task in asp.net.
Is there a way in .net to display the text automatically when i type the first letter or word in a text box? I am looking for something like MS-Excel.. In MS-Excel, if the first word is given, automatically it displays the remaining texts, only if values are given previously.
View 6 Replies
