再来高手帮帮忙
var UserInformation = from User in ((DataTable)Session["SelectCount"]).AsEnumerable().Take(100)orderby User.Field<string>("Information") descending
select new
{
UserName = User.Field<string>("UserName"),
City = User.Field<string>("City"),
VehicleLength = User.Field<string>("VehicleLength"),
MotorcycleType = User.Field<string>("MotorcycleType"),
Tonnage = User.Field<string>("Tonnage"),
Remarks = User.Field<string>("Remarks"),
LeaveType = User.Field<string>("LeaveType"),
Tell1 = User.Field<string>("Tell1"),
Time = User.Field<DateTime>("Time"),
InformationImageUrl = User.Field<string>("InformationImageUrl"),
Conditions = User.Field<string>("Conditions"),
LeaveTime = User.Field<string>("LeaveTime"),
Information = User.Field<string>("Information")
};
怎么把 UserInformation 转换成Table --------------------编程问答--------------------
--------------------编程问答-------------------- 继续在线等待 谢谢 --------------------编程问答-------------------- var UserInformation 会自动设别类型的! --------------------编程问答-------------------- DataTable table = new DataTable ();//定义表
//我不知道你说的Table是不是DataTable
DataTable dt=new DataTable();
foreach(var user in UserInformation )
{
DataRow dr=new DataRow();
...
dt.Add(dr);
}
DataColumn c1 = new DataColumn("mingzi");//定义列
.....
DataColumn c9 = new DataColumn("mingzi");
table.Columns.AddRange ( new DataColumn[] {c1,c2,...,c9}); //tbale添加列.
foreach (var user in serInformation)
{
DataRow dr = table.NewRow(); //new新行,添加数据.
dr[0] = user.UserName ;
.....
dr[9] = user. ;
table.Rows.Add (dr); //table add row
}
//over .table .
补充:.NET技术 , C#