Posts

Showing posts from December, 2012
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.
WCF video tutorial :- http://www.techscreencast.com/tag/wcf
Simple Webservice Tutorial URL http://senseware.net/Clients/icexstore/
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