Convert DataTable to Jsonresult-danejiang

Convert DataTable to Jsonresult

Time 2014-02-07 20:02:00 Blog Park-all essays area original http://www.cnblogs.com/DaneJiang/p/3539866.html

1. Get the DataTable type from the database:

DataTable dt = dbconn.getpagelist (PageIndex, PageSize, "select * from erp_process" + Pagesort, ref rowCount);

2. The DataTable is converted to VAR type:

var query = from p in dt. AsEnumerable ()
Select New
{
ID = Int. Parse (p["ID"). ToString ()),
Processcode = p["Processcode"]. ToString (),
ProcessName = p["ProcessName"]. ToString (),
Processtype = p["Processtype"]. ToString (),
Processman = p["Processman"]. ToString (),
Processtypename = typemapping (p["Processtype"]. ToString ()),
Processmanname = manmapping (p["Processman"]. ToString ())
};

3. Return Jsonresult Type:

Json (New {rows= query, total = RowCount}, jsonrequestbehavior.allowget);

Convert DataTable to Jsonresult-danejiang