Decimal Validation in asp.net C# :- <asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server" ErrorMessage="Plz Enter Only Decimal" ControlToValidate="txtMRP" ValidationExpression="^-?[0-9]{0,5}(\.[0-9]{1,2})?$|^-?(100000)(\.[0]{1,5})?$"></asp:RegularExpressionValidator> {0,5} - Indicate no.of digit to be allowed, so customized as per requirement.
Posts
Showing posts from December, 2012
- Get link
- X
- Other Apps
i ve to display data in commas in sql :- Returning a Comma CREATE FUNCTION dbo.fn_GetTherapistName(@AppCode int) RETURNS VARCHAR(1000) AS BEGIN DECLARE @StudentList varchar(1000) --SELECT @StudentList = COALESCE(@StudentList + ', ', '') + CAST(m.TherapistId AS VARCHAR(15)) --FROM multipleTherapy m --WHERE m.AppCode = @AppCode SELECT @StudentList = COALESCE(@StudentList + ', ', '') + CAST(dbo.staff_Master.firstname AS VARCHAR(100)) FROM dbo.multipleTherapy INNER JOIN dbo.staff_Master ON dbo.multipleTherapy.TherapistId = dbo.staff_Master.empcode WHERE (dbo.multipleTherapy.AppCode = @AppCode) RETURN @StudentList END