Dim rst As New ADODB.Recordset Dim cn as new adodb.connection dim a,b as string cn.connectionstring='provider=........." cn.open rst.Open "select 字段1,字段2 from TABLENAME", cn, adOpenDynamic, adLockPessimistic a = rst.Fields(0).Name '取出字段名 b=rst.fields(1).name
Dim rst As New ADODB.Recordset Dim cn as new adodb.connection dim A() as stringcn.connectionstring='provider=........." cn.open rst.Open "select * from TABLENAME", cn, adOpenDynamic, adLockPessimisticdim i as integer dim N as integer N=rst.columns.count-1 redim preserve A(N) as stringfor i = 0 to N a(i) = rst.Fields(i).Name '取出字段名 next i
Dim cn as new adodb.connection
dim a,b as string
cn.connectionstring='provider=........."
cn.open
rst.Open "select 字段1,字段2 from TABLENAME", cn, adOpenDynamic, adLockPessimistic
a = rst.Fields(0).Name '取出字段名
b=rst.fields(1).name
Dim cn as new adodb.connection
dim A() as stringcn.connectionstring='provider=........."
cn.open
rst.Open "select * from TABLENAME", cn, adOpenDynamic, adLockPessimisticdim i as integer
dim N as integer
N=rst.columns.count-1
redim preserve A(N) as stringfor i = 0 to N
a(i) = rst.Fields(i).Name '取出字段名
next i
Select Name From syscolumns Where ID In (Select ID From sysobjects Where Name='表名') Order By colorder