1、可以这样列名.属性 = table1.columns[1].att
2、gz
2、gz
解决方案 »
- 高手帮忙看看 treeView加载数据问题
- 【200分】多线程问题
- 怎样从声卡获取实时数据,在用GSM格式广播出去?
- 如何开发具有Add-Ins功能的程序?
- C#中Font类的序列化问题
- 如何检测客户是否已经安装.net
- Winfrom GDI 窗体重绘问题
- 求教,C#关于发送智能卡命令的操作问题
- 在DataGrid中嵌入ChecBox,你用过么?!!!!!!!!!!!!!!!
- 那位大侠可以给我说说什么叫"符合 CLS 的代码".
- 用C#创建了一个WinForm窗体,如何实现当打开文件时标题栏显示文件名,建立新文当就显示“未标题”?(
- 如何用C#调用脚本引擎来解释脚本并返回结果,思归等高手请进!
DataTable dbFields = myConn.GetOleDbSchemaTable (
OleDbSchemaGuid.Columns, restricts );
OleDbConnection conn = new OleDbConnection(ConnectionString);
conn.Open();
object [ ] restricts = new object [ ] {null, null, "Employees", null};
DataTable dbFields = conn.GetOleDbSchemaTable (
OleDbSchemaGuid.Columns, restricts ); foreach(DataRow dr in dbFields.Rows)
{
Console.WriteLine(dr["Column_Name"]);
}
conn.Close();
http://support.microsoft.com/default.aspx?scid=kb;en-us;q310107
给你一个我用来生成数据字典的SQL语句:select A.name as TableName, B.name as ColName, C.Name as Type,B.length,
case when B.isnullable=0 then 'NOT NULL' else 'NULL' end as 'NULL',
D.Value as Memo
from sysobjects A
left join syscolumns B on A.id=B.id
left join systypes C on C.xusertype = B.xusertype
left join sysproperties D on B.id=D.id and D.smallid=B.colid
where A.type='U' --and A.name like 'box%'
order by A.name