使用的是access数据库,要求数据表中列名保持英文,datagrid显示数据列名为中文.通过使用datatable实现.
...
string strCom = "select * from ay04";
OleDbDataAdapter thisAdapter = new OleDbDataAdapter(strCom,strConn);
DataSet thisDataSet = new DataSet();
thisAdapter.Fill(thisDataSet);
DataTable thisDataTable = thisDataSet.Tables[0];
thisDataTable.Columns["cw"].ColumnName = "层位";
this.DataGrid1.DataSource = thisDataTable;
this.DataGrid1.DataBind();