This is my code using TDBGrid7Private Sub Form_Load()
Dim i As Integer
Screen.MousePointer = vbHourglass
Me.Visible = False
Adodc1.ConnectionString = cn.ConnectionString
Adodc1.CommandType = adCmdTable
Adodc1.RecordSource = TableName
Adodc1.CursorLocation = adUseClient
Adodc1.CursorType = adOpenDynamic
Adodc1.Refresh
Screen.MousePointer = vbDefault
For i = 0 To grdSelect.Columns.Count - 1
grdSelect.Columns(i).HeadForeColor = vbWhite
grdSelect.Columns(i).HeadBackColor = &H0&
Next i
'Set colors and marquee style for the grid
grdSelect.BackColor = &HC0C0C0
grdSelect.HighlightRowStyle.BackColor = &H808080
grdSelect.HighlightRowStyle.ForeColor = &HFFFFFF
grdSelect.MarqueeStyle = 4
'Turn RecordSelectors on
grdSelect.Splits(0).RecordSelectors = True
Me.Visible = True
End Sub
Dim i As Integer
Screen.MousePointer = vbHourglass
Me.Visible = False
Adodc1.ConnectionString = cn.ConnectionString
Adodc1.CommandType = adCmdTable
Adodc1.RecordSource = TableName
Adodc1.CursorLocation = adUseClient
Adodc1.CursorType = adOpenDynamic
Adodc1.Refresh
Screen.MousePointer = vbDefault
For i = 0 To grdSelect.Columns.Count - 1
grdSelect.Columns(i).HeadForeColor = vbWhite
grdSelect.Columns(i).HeadBackColor = &H0&
Next i
'Set colors and marquee style for the grid
grdSelect.BackColor = &HC0C0C0
grdSelect.HighlightRowStyle.BackColor = &H808080
grdSelect.HighlightRowStyle.ForeColor = &HFFFFFF
grdSelect.MarqueeStyle = 4
'Turn RecordSelectors on
grdSelect.Splits(0).RecordSelectors = True
Me.Visible = True
End Sub
解决方案 »
- VB写的记事本 语法高亮部分出现的问题:编译错误 未找到方法或数据成员 求指点
- vbscript 中不支持 automation类型
- 如何下载网络上的图片,显示在image控件中,并且保持一个会话?
- 求购断点续传组件
- 疯掉了疯掉了,WINSOCK控件,第一次运行出错,终止马上再运行,正常……
- 关于MSHFlexGrid排序的问题?
- 如何用VB实现CMD的"net send XXX.XXX.XXX.XXX @#&$#@&$#@&$"
- 用过图形化编程的vb高手进来看看啊!!!
- 请问这一句该怎么理解? Asc(Format$(0.1,".")
- 怎样在vb中用insert ,updata语句进行数据库操作??????????
- 有关于fpspread6引出到EXECL问题,请教各位!
- 请大家帮忙哪位知道 下在载installshell和yiseinstall(两个安装打包软件)的地址啊???谢谢啊
如果绑定了记录集,由你的SELECT语句决定。TrueDBGrid如何定义自动列宽?
grdSelect.Columns(i).AutoSize,不过我试下来得效果不佳TrueDBGrid如何定义列标题?
grdSelect.Columns(i).Caption = "Your ColumnName"