DataGrid的,怎样自己定义datagrid表上显示的字段,50分必给!Private Sub Form_Load()
Dim Rs As New ADODB.Recordset
Dim querySql As String
querySql = "SELECT * FROM t_landrent"
Rs.CursorLocation = adUseClient
Rs.Open querySql, con, adOpenDynamic, adLockBatchOptimistic
Set DataGrid1.DataSource = Rs
End Sub
这个运行后,把DB里的数据库字段名显示出来了,可是字段名是英文的,
怎么做?多谢!
Dim Rs As New ADODB.Recordset
Dim querySql As String
querySql = "SELECT * FROM t_landrent"
Rs.CursorLocation = adUseClient
Rs.Open querySql, con, adOpenDynamic, adLockBatchOptimistic
Set DataGrid1.DataSource = Rs
End Sub
这个运行后,把DB里的数据库字段名显示出来了,可是字段名是英文的,
怎么做?多谢!
sql语句中确定显示什么字段
Set DataGrid1.DataSource = Rs
datagrid1.columns(0).caption="字段1"
datagrid1.columns(1).caption="字段2"
DataGrid1.Columns(1).Caption = "部门编号"
DataGrid1.Columns(2).Caption = "刷卡日期"
DataGrid1.Columns(3).Caption = "刷卡数据"
DataGrid1.Columns(4).Caption = "职工卡号"