.net DataTable 遍历所有列名和内容，遍历所有行和列

代码如下：

public void TestDataSet()
{
    //db达梦数据库
    using (DmConnection dmConnection = new DmConnection("Server=66.66.66.66;UserId=sa;PWD=123456;Database=PERSON"))
    {
        dmConnection.Open();
        //string sql = "select * from wac_users";
        //dm达梦数据库，查询所有表
        string sql = "select * from dba_tables";
        using (DmCommand dmCommand = new DmCommand(sql, dmConnection))
        {
            DmDataAdapter dmDataAdapter = new DmDataAdapter(dmCommand);
            DataTable dataTable = new DataTable();
            dmDataAdapter.Fill(dataTable);
            //获取datatable中的列的数量
            int columnsCount = dataTable.Columns.Count;
            //遍历所有列名和内容，遍历所有行和列
            foreach (DataRow datarow in dataTable.Rows)
            {
                for (int i = 0; i < columnsCount; i++)
                {
                    //获取列名
                    string columnName = dataTable.Columns[i].ColumnName;
                    //获取列名对应的内容
                    string columnContent = datarow[i].ToString();
                    //做一个简单的输出，输出换成其他任意方式都可以
                    Response.Body.WriteAsync(System.Text.Encoding.UTF8.GetBytes(columnName + ":" + columnContent));
                    //Response.Body.WriteAsync(System.Text.Encoding.UTF8.GetBytes(columnName + " ,  "));
                }
                Response.Body.WriteAsync(System.Text.Encoding.UTF8.GetBytes("<br/>"));
            }
        }
    }
}