如题,最好给出一下示例,谢谢!
解决方案 »
- 换个头像,散分。
- 如何用VB操作Excel转换为XML格式(介绍资料也有分)
- Clipboard中文串
- word里的selection对象和range对象有什么区别吗?我试了一下,即可以对selection里选定的字符串加批注,也可以对range对象加批注。觉得没什么区别啊。请大家讲一下。不要用官方的语言,最好说一下自己的理解和心得
- 求助:第一个VB6项目..关于数据库连接,TREE和GRID
- 为什么我date 控件连不上accsses?(初学vb.在线等)
- 关于ADO访问加了密的ACCESS
- 求助!!!DataGrid如何在运行是刷新数据
- 菜鸟问问题了:在TOOLBAR里怎么让每个BUTTOM产生事件呀
- 如何在VB中调用Adobe Acrobat编辑PDF文件?急!!!
- 远程数据源码均发出!希望查收,祝大家进步
- 求教GUID的问题。
Private Sub Command1_Click()Dim cat As ADOX.Catalog
Dim cnn As ADODB.Connection
Dim tbl As ADOX.Table
Set cat = New ADOX.Catalog
Set cnn = New ADODB.Connectioncnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\csdn_vb\查看表名\article.mdb"Set cat.ActiveConnection = cnnOn Error Resume Next'Set tbl = cat.Tables("MyTable")
For Each tbl In cat.Tables
If Left(tbl.Name, 4) <> "MSys" Then
List1.AddItem tbl.Name
End If
NextSet cat = NothingSet con = NothingEnd Sub
cnnTemp.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog= Master;Data Source=server;password = rising"
cnnTemp.Open
Dim rstDataBase As New ADODB.Recordset
Dim strSQL As String
strSQL = "Select * From SysDatabases "
rstDataBase.Open strSQL, cnnTemp, adOpenStatic, adLockReadOnly
Do While Not rstDataBase.EOF
Me.cboDataBase.AddItem rstDataBase!Name
rstDataBase.MoveNext
Loop
rstDataBase.Close
Set rstDataBase = Nothing
cnnTemp.Close
Set cnnTemp = Nothing
表名=CASE WHEN a.colorder=1 THEN d.name ELSE '' END,
自动序号=a.colorder,
字段名=a.name,
标识=CASE WHEN COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 THEN '√'ELSE '' END,
主键=CASE WHEN EXISTS(SELECT 1 FROM sysobjects WHERE xtype='PK' AND name IN (
SELECT name FROM sysindexes WHERE indid IN(
SELECT indid FROM sysindexkeys WHERE id = a.id AND colid=a.colid
))) THEN '√' ELSE '' END,
类型=b.name,
占用字节数=a.length,
长度=COLUMNPROPERTY(a.id,a.name,'PRECISION'),
小数位数=ISNULL(COLUMNPROPERTY(a.id,a.name,'Scale'),0),
允许空=CASE WHEN a.isnullable=1 THEN '√' ELSE '' END,
默认值=ISNULL(e.text,''),
字段说明=ISNULL(g.[value],'')
FROM syscolumns AS a
LEFT JOIN systypes AS b ON a.xtype=b.xusertype
INNER JOIN sysobjects AS d ON a.id=d.id AND d.xtype='U' AND d.name<>'dtproperties'
LEFT JOIN syscomments AS e ON a.cdefault=e.id
LEFT JOIN sysproperties AS g ON a.id=g.id AND a.colid=g.smallid
ORDER BY a.id,a.colorder