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;
}
{
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;
}
0 Comments
if you have any doubts , please let me know