string MySelectStr = "";
MySelectStr = "select * from SUBJECT";
OleDbConnection myConnection = DataConnection.Instance.GetConnection();
DataSet dataView = new DataSet();
OleDbDataAdapter myAdapter = new OleDbDataAdapter(MySelectStr,myConnection);
myAdapter.Fill(dataView);
myConnection.Close();
DataTable myDataTable = dataView.Tables[0];
this.SUBJECT.DataSource = myDataTable;
DataGridTableStyle ds = new DataGridTableStyle(true);
ds.DataGrid = this.SUBJECT;
ds.MappingName = myDataTable.TableName;
this.SUBJECT.TableStyles.Clear();
this.SUBJECT.TableStyles.Add(ds);
ds.GridColumnStyles[0].HeaderText = "编号";
ds.GridColumnStyles[0].Width = 100; '第一列,列宽100
ds.GridColumnStyles[0].MappingName = "SUBJECTID";
ds.GridColumnStyles[1].HeaderText = "科目名称";
ds.GridColumnStyles[1].Width = 0; ‘第二列,宽度为0 则隐藏
ds.GridColumnStyles[1].MappingName = "SUBJECTNAME";
转载于:https://www.cnblogs.com/hzuIT/articles/472793.html