c# - 从数据表填充 Gridview

Question

我正在尝试从数据表填充 Gridview。但是，当我运行代码时，Gridview 中什么也没有显示。这是代码:

string serverIP = drpServer.SelectedItem.Value.ToString();
ManagementObjectSearcher searcher = new ManagementObjectSearcher(@"\\" + serverIP + "\\root\\CIMV2", "SELECT * FROM Win32_PerfFormattedData_PerfProc_Process");

        foreach (ManagementObject query in searcher.Get())
        {               
            var processName = query["Name"];
            var processID = query["IDProcess"];
            var cpuTime = query["PercentProcessorTime"];
            var memUsage = query["WorkingSet"];

            double newMemUsage = Convert.ToDouble(memUsage);

            newMemUsage = newMemUsage / 1024;

            DataTable dt = new DataTable();
            dt.Columns.Add("ProcessName", typeof(string));
            dt.Columns.Add("ProcessID", typeof(int));
            dt.Columns.Add("CPUTime", typeof(string));
            dt.Columns.Add("MemoryUsage", typeof(string));

            DataRow row = dt.NewRow();
            row["ProcessName"] = processName;
            row["ProcessID"] = processID;
            row["CPUTime"] = cpuTime;
            row["MemoryUsage"] = newMemUsage;
            dt.Rows.Add(row);

            GridView1.DataSource = dt;
            GridView1.DataBind();

与使用 Diagnostics.Process 相比，我更喜欢 Management Object Searcher，这就是我选择这条路线的原因。

我也在我的 Gridview 中创建了绑定(bind)字段。

Answer 1

为什么您的 foreach 包装了整个过程？这将在您每次收到新查询时创建一个全新的 DataTable。我认为您打算执行以下操作，它只包装添加行:

string serverIP = drpServer.SelectedItem.Value.ToString();
ManagementObjectSearcher searcher = new ManagementObjectSearcher(@"\\" + serverIP + "\\root\\CIMV2", "SELECT * FROM Win32_PerfFormattedData_PerfProc_Process");

DataTable dt = new DataTable();
dt.Columns.Add("ProcessName", typeof(string));
dt.Columns.Add("ProcessID", typeof(int));
dt.Columns.Add("CPUTime", typeof(string));
dt.Columns.Add("MemoryUsage", typeof(string));

foreach (ManagementObject query in searcher.Get())
{   
    var processName = query["Name"];
    var processID = query["IDProcess"];
    var cpuTime = query["PercentProcessorTime"];
    var memUsage = query["WorkingSet"];

    double newMemUsage = Convert.ToDouble(memUsage);

    newMemUsage = newMemUsage / 1024;

    DataRow row = dt.NewRow();
    row["ProcessName"] = processName;
    row["ProcessID"] = processID;
    row["CPUTime"] = cpuTime;
    row["MemoryUsage"] = newMemUsage;
    dt.Rows.Add(row);
}

GridView1.DataSource = dt;
GridView1.DataBind();