Linq循环DataTable,使用匿名对象取出需要的列
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 | var g_id = context.Request[ "g_id" ]; DataTable dt = new DataTable(); var sql = @"select a.g_name ,c.cl_name ,c.cl_type ,c.cl_hidden ,c.grid_inner_order ,c.editor ,c.sum_able ,q.f_name ,q.f_type from tbl_grid a --列 left join tbl_grid_column_mapping b on a.g_id=b.g_id LEFT JOIN tbl_column c on c.cl_id=b.cl_id --filed left join tbl_column_field_mapping w on w.cl_id=b.cl_id left join tbl_field q on q.f_id= w.f_id where a.g_id='" + g_id+"'"; try { dt = dataprovider.FillDataTable(sql, CommandType.Text); string grid_name = dt.Rows[0][ "g_name" ].ToString(); var column = dt.AsEnumerable().Select(n => new { key = n.Field< string >( "f_name" ), value = n.Field< string >( "cl_name" ) }).ToList(); context.Response.Write( "{\"g_name\": " + grid_name + ",\"column\":" + JsonConvert.SerializeObject(column) + "}" ); } catch (Exception e) { context.Response.Write( "失败:" + e.Message); } |
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步