得到 sql表的字段和类型

select   name   from   syscolumns   where   id   =   object_id('user')

select a.name as [column],b.name as type from syscolumns a,systypes b where a.id=object_id('user') and a.xtype=b.xtype and a.name='userid'

表清单

conn.Open();     dt= conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });

表结构

conn.Open();

                dtColumnsInfo = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[] { null, null, strTableName,null });

转载于:https://www.cnblogs.com/wolfcool/archive/2009/05/15/1457595.html