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();
}
}
