A blog about Programming
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE"value="/wEPDwUJNzg0MDMxMDA1D2QWAmYPZBYCZg9kFgQCAQ9kFgICBQ9kFgJmD2QWAgIBDxYCHhNQcm...
ZpZ2F0aW9uTWVudQ8PZAUKQWxsIGluIE9uZWQiMPVaPthHdSA3rH8zgoNOvWxd4w==" /><input type="hidden" name="__NCPVIEWSTATE" id="__NCPVIEWSTATE"value="vs:cf8c8d3927ad4c1a84da7f891bb89185" /> <input type="hidden"name="__VIEWSTATE" id="__VIEWSTATE" value="" />
namespace TestOverloadingWebService
{
[WebService(Namespace = "http://tempuri.org/", Description=" Function
overloading in Web Services ")]
public class OverloadingInWebService : System.Web.Services.WebService
{
[WebMethod()]
public int Add(int a, int b)
{
return (a + b);
}
[WebMethod()]
public float Add(float a, float b)
{
return (a + b);
}
}
}
OverloadingInWebService. In the Web Service, we have added attribute Description, which is used to describe the web service purpose to client. In the above Web Service, we have two overloaded WebMethods:public int Add(int a, int b)
public float Add(float a, float b)
Descriptionproperty to add a description of web method and MessageName property to change web method name.[WebMethod(MessageName = "" , Description = "" )]
namespace TestOverloadingWebService
{
[WebService(Namespace = "http://tempuri.org/", Description=" Function
overloading in Web Services ")]
public class OverloadingInWebService : System.Web.Services.WebService
{
[WebMethod(MessageName = "AddInt", Description = "Add two integer
Value", EnableSession = true)]
public int Add(int a, int b)
{
return (a + b);
}
[WebMethod(MessageName = "AddFloat", Description = "Add two Float
Value", EnableSession = true)]
public float Add(float a, float b)
{
return (a + b);
}
}
}
MessageName Property’, it changes the method name in WSDL. See the WSDL given below, the operation name is Add but the input method name is AddInt as well as output method name is also same (AddInt). The same will apply for Float also.Descriptionproperty to add a description of web method and MessageName property to change web method name.[WebMethod(MessageName = "" , Description = "" )]
namespace TestOverloadingWebService
{
[WebService(Namespace = "http://tempuri.org/", Description=" Function
overloading in Web Services ")]
public class OverloadingInWebService : System.Web.Services.WebService
{
[WebMethod(MessageName = "AddInt", Description = "Add two integer
Value", EnableSession = true)]
public int Add(int a, int b)
{
return (a + b);
}
[WebMethod(MessageName = "AddFloat", Description = "Add two Float
Value", EnableSession = true)]
public float Add(float a, float b)
{
return (a + b);
}
}
}
MessageName Property’, it changes the method name in WSDL. See the WSDL given below, the operation name is Add but the input method name is AddInt as well as output method name is also same (AddInt). The same will apply for Float also.<wsdl:operation name="Add">
<wsdl:documentation xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">Add
two integer Value</wsdl:documentation>
<wsdl:input name="AddInt" message="tns:AddIntSoapIn" />
<wsdl:output name="AddInt" message="tns:AddIntSoapOut" />
</wsdl:operation>
<wsdl:operation name="Add">
<wsdl:documentation xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">Add
two Float Value</wsdl:documentation>
<wsdl:input name="AddFloat" message="tns:AddFloatSoapIn" />
<wsdl:output name="AddFloat" message="tns:AddFloatSoapOut" />
</wsdl:operation>
CREATE TRIGGER LogMessage ON EMP FOR INSERT AS DECLARE @EMPNAME varchar(50) SELECT @EMPNAME= (SELECT EMPNAME FROM INSERTED) INSERT INTO LOGTABLE(UserId,Message) values (@EMPNAME,'Record Added') GOWhen we delete the record from the table, the magic table "DELETED" will be created
CREATE TRIGGER LogMessage ON EMP FOR DELETE AS DECLARE @EMPNAME varchar(50) SELECT @EMPNAME= (SELECT EMPNAME FROM DELETED) INSERT INTO LOGTABLE(UserId,Message) values (@EMPNAME,'Record Removed') GOThe magic tables "INSERTED" and "DELETED" are main concept of the "TRIGGER".
