public static object GetData(string actionName, string value) { var command = DataAccess.CreateCommand(); try { command.CommandText = actionName; command.Parameters.AddWithValue("@pkId", value); command.Connection.Open(); var adp = new SqlDataAdapter(command); var ds = new DataSet(); adp.Fill(ds); var rows = DataUtilities.ConvertDSToList(ds); // return rows.ToList(); var serializer = new JavaScriptSerializer(); return(serializer.Serialize(rows)); } catch (Exception ex) { //throw ex; return(ex.Message); } finally { command.Connection.Close(); } }