private void dataGV_SAP_1_CellContentClick(object sender, EventArgs e) { try { var V = from t in PubDt.AsEnumerable() group t by new { t1 = t.Field <string>("SerialNumber"), t2 = t.Field <string>("MatNumber") } into m select new { SNRSum = m.Count(), SNR = m.Key.t1, Material_ID = m.Key.t2 }; if (V.ToList().Count > 0) { dataGV_SAP_2.DataSource = V.ToList(); dataGV_SAP_2.ColumnHeadersDefaultCellStyle.Font = new Font("雅黑", 10, FontStyle.Bold); dataGV_SAP_2.ColumnHeadersDefaultCellStyle.ForeColor = Color.Purple; dataGV_SAP_2.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dataGV_SAP_2.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; } var Mt = from ty in PubDt.AsEnumerable() group ty by new { ty1 = ty.Field <string>("MoveType") } into Cl select new { ConsumeType = Cl.Key.ty1, ConsumeCount = Cl.Count() }; if (Mt.ToList().Count > 0) { DGV_MoveType.DataSource = Mt.ToList(); DGV_MoveType.AllowUserToAddRows = false; DGV_MoveType.Rows[0].Cells[0].Style.BackColor = Color.Empty; } PubDt.Clear(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }