Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim str As String
Dim strSql As String
str = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password = password;Initial Catalog=dmd;Data Source=USTC-CHENLUFENG"
Set conn = New ADODB.Connection
conn.Open (str)
strSql = "SELECT from home where name= 'txtName.Text'"
rs.Open strSql, cnnn, adOpenStatic, adLockOptimistic ---->这句出错!
Set ms.DataSource = rs
conn.Cancel
rs.Cancel
Dim rs As New ADODB.Recordset
Dim str As String
Dim strSql As String
str = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password = password;Initial Catalog=dmd;Data Source=USTC-CHENLUFENG"
Set conn = New ADODB.Connection
conn.Open (str)
strSql = "SELECT from home where name= 'txtName.Text'"
rs.Open strSql, cnnn, adOpenStatic, adLockOptimistic ---->这句出错!
Set ms.DataSource = rs
conn.Cancel
rs.Cancel
解决方案 »
- 为什么接收到的点的横坐标没变?
- 怎么捕获webbrowser上的F1~F12等功能键
- 急,在线等!
- 需要ProducerControl.ocx这个控件?????????????
- 老大帮忙!!!关于数据库记录导出的问题
- 关于mschart控件的问题
- 要用data report 来打印单据,打印机是专用的票据打印机,纸是一卷的那种啊,怎么控制
- 用vb如何实现将汉字转换成拼音?
- 程序有错 强帮忙调试一下
- 谁有能用的setup factory,发给我 [email protected]
- 我编写了一个程序,如何让它一天的某个时刻执行一次?
- tdbgrid7.0慢慢!我的物料编号对应的“名称规格”是采用非绑定的即UnboundColumnFetch,当数据一多(100以上)就慢很多了。如何处理,求
MSG.Rows '总行数
MSG.Cols '总列数
MSG.TextMatrix(Row,Col)="内容"
MSG.RowHeight '设定行高
MSG.ColWidth '设定列宽
MSG.FixedCols '设定固定列数
MSG.FixedRows '设定固定行数
TxtName如果是TextBox的话改为
strSql = "SELECT from home where name= txtName.Text"
即可,引用对象值或变量不用加单引号
应该是下面这样吧!strSql="SELECT from home where name='" & txtName.Text & "'"
应该是
引用对象值或变量的时候,应改为
strSql = "SELECT from home where name='" & txtName.Text & "'"
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim str As String
Dim strSql As String
str = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password = password;Initial Catalog=dmd;Data Source=USTC-CHENLUFENG"
Set conn = New ADODB.Connection
conn.Open (str)
strSql = "SELECT from home where name='" & txtName.Text & "'"
rs.Open strSql, cnnn, adOpenStatic, adLockOptimistic ----错误依旧!
Set ms.DataSource = rs
conn.Cancel
rs.Cancel
End Sub
少了字段名称
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim str As String
Dim strSql As String
str = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password = password;Initial Catalog=dmd;Data Source=USTC-CHENLUFENG"
Set conn = New ADODB.Connection
conn.Open (str)
strSql = "SELECT * from home where name='" & txtName.Text & "'" -------兄弟们,还是不行。
rs.Open strSql, cnnn, adOpenStatic, adLockOptimistic
Set ms.DataSource = rs
conn.Cancel
rs.Cancel
End Sub
cnnn-〉conn
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim str As String
Dim strSql As String
str = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password = password;Initial Catalog=dmd;Data Source=USTC-CHENLUFENG"
Set conn = New ADODB.Connection
conn.Open (str)
strSql = "SELECT * from home where name='" & txtName.Text & "'"
Call rs.Open(strSql, conn, adOpenDynamic, adLockOptimistic)
Adodc1.RecordSource = strSql \________这样写就没问题了!
Set ms.DataSource = Adodc1 /
ms.Refresh
conn.Cancel
rs.Cancel
End Sub
我终于解决这个问题了,现在这个表可以正常运行了.谢谢大家的帮忙!我的问题好像处在adodc1的属性设置上了,我这个mshflexgrid是打算现实查询结果的,但是我开始adodc1设置的是“2-adCmdTable”应该社成“1-adCmdText”就可以了。