下面怎么写能够将DATAGRID的RECORDSET设置为rs?
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim str As String
Set cn = New ADODB.Connection
cn.ConnectionString = "provider=sqloledb.1;data source=(local);user id=ss;pwd=ss;initial catalog=sdb"
cn.Open
str = "select * from Users where UserName='" & Trim(Text1.Text) & "'"
Set rs = New ADODB.Recordset
rs.Open str, cn, adOpenStatic, adLockOptimistic
2005-11-12 20:41
2005-11-17 18:08
这样写好像不行啊
2005-11-17 21:41
下面怎么写能够将DATAGRID的RECORDSET设置为rs?
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim str As String
Set cn = New ADODB.Connection
cn.ConnectionString = "provider=sqloledb.1;data source=(local);user id=ss;pwd=ss;initial catalog=sdb"
cn.Open
str = "select * from Users where UserName='" & Trim(Text1.Text) & "'"
Set rs = New ADODB.Recordset
rs.Open str, cn, adOpenStatic, adLockOptimistic
大家好！我是VB新手！请教大家如下问题：
象上面的连接！怎么样写一个完整的在SQL数据库中添加数据、修改数据和删除数据！
谢谢大家能给予帮助！！
请联系QQ453831753
或lcy@bestwinning.com.cn
2005-11-23 15:49
用楼主代码中的cn.Execute([T-SQL语句])的方法就可以添加和修改数据。
T-SQL语句相关连接
http://bbs.bc-cn.net/bbs/dispbbs.asp?boardID=6&ID=33918&page=1
2005-11-23 15:52
