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?
I 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>
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 RepliesI want user to enter name in Arabic if the user enter in english it should give Message " Enter Message In Arabic " and same for English if user try to enter in arabic it should give a message "Enter Name in English" ...
View 1 RepliesI want to restrict the user in toolbar search by not allowing him/her using Some Special Characters like
('/','>','<','|').
$("#tblFundComp").bind("keydown",function(e)
{
if(e.keyCode >=48 && e.keyCode <=57 ) [code].....
I have placed this piece of code after before search function. But this does not work
i am making a webform for university students to register projects.there is a dropdown list which will ask how many students have participated, suppose student select 3 students, now my question is how can i restrict user to enter only one students data,i want he/she should fill all three students data than the submit button should enabled.
View 5 RepliesI have developed a ASP.NET application,I have used sessions for parameter passing.I dont want to let the user to enter data when the session expired.Please suggest me how to do that.
View 1 RepliesI gave an option to user to change password but the text boxes are taking - / @ (special characters). How to check at runtime that user may not enter these characters?
View 21 RepliesI list selections of available items in a gridview and have added a button column for adding items to a cart. Is there a way to add a column where the user can enter the quantity to add?
View 1 RepliesI have to create a text box where if user will enter something it should show the values from database like google shows.e.g If i press a it should display a if i have entered AJ it should show all the list which start from AJ.Same like google.
View 10 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 can i insert 'null' value in numeric column if no record is there.when i pass record to BLL like
MyCollegeAddmissionMst.GraduationYear = IIf(txtGrdyear.Text = String.Empty,
"", txtGrdyear.Text.Trim())
datatype is numeric(4,0) then error is Conversion from string "" to type 'Integer' is not valid. no record is in this textbox and i need to entry null value.so how can i do the same.
How 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 am trying to find the column length of a particular sql table, it is working very fine if its 'nvarchar' or 'text' type. But if i try to get the numeric(int/bigint/bit) data type i am getting error. please help me out. The sample code is given below for you reference,'*** Source Code Start
Dim da
As
New OleDbDataAdapter(strQuery, PortalConn)
[code]...
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]....
Me with C# asp.net, how can I validate a text box such that it should accept only numeric values and -
View 6 RepliesIn 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 RepliesFor 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 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 to restrict the other user if one works on the particular record.
i am having a table with the name tblProduct and i used to edit the records from the code behind using my website.
When one user login into the site and search for the particular products and edits the product and at the same time other user log in and try to edit the same product, i need to show the alert message, "the user (username) is already working on this. please wait for a while."
Is there a way to restrict being able to edit a gridview column to some users but not to others ? Say setting the column to read only and then resetting it when the row is in edit mode.
View 2 Replies