我先查询数据库中表的字段: 代码如下: view plaincopy to clipboardprint? /// <summary> /// 获得字段名称 /// </summary> /// <param name="view">要显示的DataGridView</param> /// <param name="tablename">获得字段的表名</param> public static void GetField;(DataGridView view,string tablename) { view.Rows.Clear(); DataTable table = null; table = DBHelper.GetSchemaUsingOleDbDataReader(tablename); for (int i = 0; i < table.Rows.Count; i++) { view.Rows.Add(1); view.Rows[view.Rows.Count - 1].Cells[0].Value = (object)table.Rows[i].ItemArray[0].ToString(); if (table.Rows[i].ItemArray[0].ToString() != "序号") view.Rows[view.Rows.Count - 1].Cells[1].Value = (object)"允许修改"; else view.Rows[view.Rows.Count - 1].Cells[1].Value = (object)"禁止修改"; if (table.Rows[i].ItemArray[5].ToString() == "System.Int32") view.Rows[view.Rows.Count - 1].Cells[2].Value = (object)"整数型(系统保留)"; else if (table.Rows[i].ItemArray[5].ToString() == "System.DateTime") view.Rows[view.Rows.Count - 1].Cells[2].Value = (object)"日期型(系统保留)"; else if (table.Rows[i].ItemArray[5].ToString() == "System.Double") view.Rows[view.Rows.Count - 1].Cells[2].Value = (object)"小数型(系统保留)"; else { view.Rows[view.Rows.Count - 1].Cells[2].Value = (object)"字符型(长度):" + table.Rows[i].ItemArray[2].ToString(); } } } /// <summary> /// 获得字段名称 /// </summary> /// <param name="view">要显示的DataGridView</param> /// <param name="tablename">获得字段的表名</param> public static void GetField;(DataGridView view,string tablename) { view.Rows.Clear(); DataTable table = null; table = DBHelper.GetSchemaUsingOleDbDataReader(tablename); for (int i = 0; i < table.Rows.Count; i++) { view.Rows.Add(1); view.Rows[view.Rows.Count - 1].Cells[0].Value = (object)table.Rows[i].ItemArray[0].ToString(); if (table.Rows[i].ItemArray[0].ToString() != "序号") view.Rows[view.Rows.Count - 1].Cells[1].Value = (object)"允许修改"; else view.Rows[view.Rows.Count - 1].Cells[1].Value = (object)"禁止修改"; if (table.Rows[i].ItemArray[5].ToString() == "System.Int32") view.Rows[view.Rows.Count - 1].Cells[2].Value = (object)"整数型(系统保留)"; else if (table.Rows[i].ItemArray[5].ToString() == "System.DateTime") view.Rows[view.Rows.Count - 1].Cells[2].Value = (object)"日期型(系统保留)"; else if (table.Rows[i].ItemArray[5].ToString() == "System.Double") view.Rows[view.Rows.Count - 1].Cells[2].Value = (object)"小数型(系统保留)"; else { view.Rows[view.Rows.Count - 1].Cells[2].Value = (object)"字符型(长度):" + table.Rows[i].ItemArray[2].ToString(); } } } 这里面有一个查询数据表的字段的方法: 如下: view plaincopy to clipboardprint? /// <summary> /// 获得表的字段信息 /// </summary> /// <param name="connString"></param> /// <returns></returns> public static DataTable GetSchemaUsingOleDbDataReader(string tablename) {