Hi anita.roy,
Refer the below code and change your code like below.
HTML
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script type="text/javascript">
function getValuesFromPSS(s, e) {
var mechName = 'abc';
if (mechName != "Others") {
PageMethods.GetFPCCodeFromPSS(mechName, OnSuccess);
}
function OnSuccess(response, userContext, methodName) {
alert(response);
}
}
</script>
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true">
</asp:ScriptManager>
<div>
<input id="btnGetValuesFromPSS" type="button" value="Get Values From PSS" onclick="getValuesFromPSS()" />
</div>
</form>
</body>
</html>
Code
[System.Web.Services.WebMethod]
public static string GetFPCCodeFromPSS(string moa)
{
string query = "SELECT Disc_Project_Tracking_Code FROM [PSUMSERVER]." + Convert.ToString(ConfigurationManager.AppSettings["PTDB"]) + ".dbo.ProjSumm_Project_CS WHERE Disc_Project_Name = '" + moa + "'";
DataFacade df = new DataFacade(query);
DataTable dt = df.getData();
string fpc = string.Empty;
foreach (DataRow dr in dt.Rows)
{
fpc = Convert.ToString(dr["Disc_Project_Tracking_Code"]);
}
return fpc;
}
For more details on PageMethod refer below article.