how to get list json action result in asp.net mvc

in this article, I will show you, how to return jsonresult with list object in asp.net mvc

public JsonResult GetTaskDescription(string id)
{
    id = id.ToUpper();
    List<ABC> List = new List<ABC>();
    List = Get_TblList(id);
    var AbcList = (from e in List
        select new
            {
                Value = e.ID,
                Text = e.DESC,
            }).Distinct().ToList();
    return Json(AbcList, JsonRequestBehavior.AllowGet);
}

public DataTable Get_TblList(string id)
{
//string SQRY = "SELECT * FROM ABC";
    string SQRY = "exec USP_GetAbcData '" + id + "' ";
    DataTable DT = GetDataTableFromSP(SQRY);
    return DT;
}

string ConStr = ]System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;

public string GetConnstr()
{
    return ConStr;
}

public DataTable GetDataTableFromSP(string SQRL)
{
    DataTable DT = GetTablefromQuery(SQRL);
    return DT;
}

public DataTable GetTablefromQuery(string SQRL)
{
    DataTable DT = new DataTable();
    var conn = new SqlConnection(ConStr);
    using (var cmd = conn.CreateCommand())
    {
        cmd.CommandText = SQRL;
        cmd.CommandTimeout = 6000;
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        conn.Close();
        da.Fill(DT);
        da.Dispose();
        conn.Close();
    }
    return DT;
}

Post a Comment

0 Comments