我的数据库也连好了,没有报错..怎么查询后没有结果显示呢.请高手指点!!!!!!!!!急.........
解决方案 »
- 求教
- DateCreated 创建时间问题
- 双击关联文件出错, 有谁遇到过这种情况?
- 在VB中如何确定某控件的类型?
- 关于script control的简单使用问题
- 在2beesoft网站上下载过icon的人请进!!!
- 这是怎么回事?
- 怎么找不到要调用的dll?
- 请教如何用VB把一个数据库中的字段名导入到另一个数据库的记录中1
- 请问怎样在VB6里用win98里的画笔调用一指定文件?
- VB如何判断本机(192.168.5.1)与远程主机(如192.168.2.1)是否联通?如何判断本机已经联网或不联网状态?
- 高手救助,VB中如何用api判断操作系统是win2000 pro 还winXP home or winxp Pro?
你试试这样做,引用ado
Dim Con As ADODB.Connection
Dim rs As ADODB.Recordset
Set Con = New ADODB.Connection
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\计划管理系统.mdb;Persist Security Info=False"
Con.Open strCon
Set rs = New ADODB.Recordset
'添加记录
strsql="select * from 表 where id=2"
rs.Open strsql, Con, adOpenKeyset, adLockOptimistic
'输出id=2的一个字段
msgbox rs!字段
rs.close
set rs=nothing
Private Sub Command1_Click()
On Error GoTo err
Dim cn As New ADODB.Connection, rs As New ADODB.RecordSet
'有密码的连接:
'cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=登陆用户名;Password=登录密码;Initial Catalog=数据库名;Data Source=服务器别名"
'无密码的连接:
cn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=数据库名;Data Source=服务器别名"
cn.Open
rs.CursorLocation=adUseClient'设置客户端游标
rs.Open "select * from 你的表 where ...", cn, 3, 2
If rs.Eof Then Msgbox "没有符合条件的记录"
whlie not rs.eof
Combo1.AddItem rs.Fields("你需要的列名").value
rs.MoveNext
wend
Exit Sub
err:
MsgBox err.Description
End Sub
On Error Resume Next
Dim i As Integer
Text2 = ""
For i = 0 To DataGrid1.Columns.Count - 1
Text2 = Text2 & DataGrid1.Columns(i).Value & "|"
Next
End SubPrivate Sub Form_Activate()
List1.Clear
List1.AddItem "查询MO"
List1.AddItem "查询MT"
End SubPrivate Sub List1_Click()
Dim QueStr As String
Select Case List1
Case "查询MO"
QueStr = "select destination_id as 特服号,src_terminal_id as 手机号,convert(varchar(255),msg_content) as 内容,ih_timestamp as 时间 from inhand40.dbo.cmpp_deliver where src_terminal_id='" & Text1 & "' order by id desc"
Case "查询MT"
QueStr = "select src_terminal_id as 特服号,dest_terminal_id as 手机号,convert(varchar(255),msg_content) as 内容,ih_timestamp as 时间 from inhand40.dbo.cmpp_submit where dest_terminal_id='" & Text1 & "' order by id desc"
End Select
Adodc1.ConnectionString = Conn.ConnectionString
Adodc1.RecordSource = QueStr
Set DataGrid1.DataSource = Adodc1
Adodc1.Refresh
DataGrid1.Refresh
DataGrid1.Columns(0).Width = 800
DataGrid1.Columns(1).Width = 1200
DataGrid1.Columns(2).Width = 4200
DataGrid1.Columns(3).Width = 1800
Label2 = "共" & Adodc1.Recordset.RecordCount & "条记录"
End Sub
---------------
你是说DataGrid没内容?