.net DataTable 遍历所有列名和内容,遍历所有行和列 电脑版发表于:2018/3/9 11:12 代码如下: ```c# 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/>")); } } } } ```