杭州交通信息网anet硅谷动力学院:VB数据库多条件查询
来源：百度文库 编辑：杭州交通信息网 时间：2024/04/28 03:50:54
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
conn.ConnectionString = "provider=sqloledb.1;persist security info=false;user id=sa;password=;initial catalog=northwind;data source=microsof-0d1123"
conn.Open
rs.CursorLocation = adUseClient
说明:本人想对ORDERS表进行查询,条件为orderid以11开头,orderdate区间为1998-1-1至1998-4-30
*表中orders的orderdate格式为日期时间格式
问题:rs.open如何写?
谢谢大家的热心解答!
Set DataGrid1.DataSource = rs
Set conn = Nothing
Set rs = Nothing
首先谢谢幸巴达和先锋互动两面位高人,但本人想要连rs.open的完整语句
Dim rs As New ADODB.Recordset
conn.ConnectionString = "provider=sqloledb.1;persist security info=false;user id=sa;password=;initial catalog=northwind;data source=microsof-0d1123"
conn.Open
rs.CursorLocation = adUseClient
说明:本人想对ORDERS表进行查询,条件为orderid以11开头,orderdate区间为1998-1-1至1998-4-30
*表中orders的orderdate格式为日期时间格式
问题:rs.open如何写?
谢谢大家的热心解答!
Set DataGrid1.DataSource = rs
Set conn = Nothing
Set rs = Nothing
首先谢谢幸巴达和先锋互动两面位高人,但本人想要连rs.open的完整语句
如果orderid是int型就改为
Select * from [tablename] where cast(orderid as varchar) like '11%' and orderdate between '1998-1-1' and '1998-4-30'
Select * from [tablename] where orderid like '11%' and orderdate between 1998-1-1 and 1998-4-30