public static string GetSpFacevalue(string pregistration_no, string pinstrument_number) { SpManager spManager = new SpManager(); Dictionary <string, object> inputParam = new Dictionary <string, object>(); inputParam.Add("pregistration_no", pregistration_no); inputParam.Add("pinstrument_number", pinstrument_number); DataTable dt = spManager.GetImportedSpFacevalue(inputParam); HttpContext.Current.Session["SpFaceValue"] = dt; DataTable filteredData = new DataTable(); filteredData.Columns.Add("INSTRUMENT_NUMBER"); filteredData.Columns.Add("DENOMINATION"); foreach (DataRow dr in dt.Rows) { DataRow row = filteredData.NewRow(); row["INSTRUMENT_NUMBER"] = dr["INSTRUMENT_NUMBER"]; row["DENOMINATION"] = dr["DENOMINATION"]; filteredData.Rows.Add(row); } return(DatatableToJson(filteredData)); }