Char绑定list数据,DataTable.Compute方法

来源:互联网 发布:梅长苏同款披风 淘宝 编辑:程序博客网 时间:2024/05/21 09:07
           GoodsManagementDataContext cxt = new GoodsManagementDataContext();            var data = from r in cxt.GoodsType                       join a in cxt.Goods on r.typeid equals a.typeid                       //select new { r.typename, r.typeid };                       group r by r.typeid;            List<string> nameList = new List<string>();            List<string> countList = new List<string>();            DataTable dt = new DataTable();            dt.Columns.Add("name");            dt.Columns.Add("count",typeof(Int16));//类型转换成Int            foreach (var item in data)            {                countList.Add(item.Count().ToString());                DataRow dr = dt.NewRow();                dr[1] = item.Count().ToString();                foreach (var child in item)                {                    dr[0] = child.typename.ToString();                    nameList.Add(child.typename.ToString());                    break;                }                dt.Rows.Add(dr);            }            chart1.Series[0].Points.DataBindXY(nameList, countList);            chart1.Series[0].IsValueShownAsLabel = true;            chart1.Titles.Add("This is a GoodsType Count");            string max = dt.Compute("max(count)", "1=1").ToString();//计算方法:计算最大的Count            DataRow[] rows = dt.Select("count=" + max);            lbName.Text = rows[0]["name"].ToString();            lbCount.Text = max;

0 0
原创粉丝点击