数据库中数据提取不同值
sql = "SELECT id,no,partno,model FROM Master"
遍历JX_Product_Master的值如下：
no partno model
1 sa pro
2 ds pro
3 kk pro
4 ks pro1
5 kad pro1
求分组的方法。要求把上边的值分成pro pro1二组，高人指点
set = WebData1.dataSet(sql);
foreach (DataRow drow in set.Tables[0].Rows)
{
//怎么判断字段model变化
}
[解决办法]
我写了段代码不知道是不是楼主要的意思：
private DataTable InitTable() { DataTable dt = new DataTable(); dt.Columns.Add("no"); dt.Columns.Add("partno"); dt.Columns.Add("model"); return dt; } private void button1_Click(object sender, EventArgs e) { DataTable dt = this.InitTable(); DataRow dr; dr = dt.NewRow(); dr["no"] = "1"; dr["partno"] = "1_1"; dr["model"] = "pro"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["no"] = "2"; dr["partno"] = "2_1"; dr["model"] = "pro"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["no"] = "3"; dr["partno"] = "3_1"; dr["model"] = "pro1"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["no"] = "4"; dr["partno"] = "4_1"; dr["model"] = "pro1"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["no"] = "5"; dr["partno"] = "5_1"; dr["model"] = "pro2"; dt.Rows.Add(dr); //实现分组 IDictionary<string, DataTable> tables = new Dictionary<string, DataTable>(); foreach (DataRow r in dt.Rows) { string model = r["model"].ToString(); DataTable newTable; if (!tables.ContainsKey(model)) { newTable = this.InitTable(); tables.Add(model, newTable); } else { newTable = tables[model]; } DataRow newRow = newTable.NewRow(); for (int j = 0; j < dt.Columns.Count; j++) { newRow[j] = r[j]; } newTable.Rows.Add(newRow); } foreach (KeyValuePair<string, DataTable> keyAndValue in tables) { MessageBox.Show("model=" + keyAndValue.Key + "的表数据行数为：" + keyAndValue.Value.Rows.Count.ToString()); } }