sql server7.0
vb6.0
xp
vb6.0
xp
解决方案 »
- 帮忙改程序,送手机话费50元
- 翻译vb到delphi,哪位精通这两门最好懂MO的来翻译下
- 关于Excel报表生成的问题,总是说 range 的_application方法失败,为什么呀
- vba是什么东西
- 如何实现进程保护?????????????????????[例如:关不掉,或者关掉后立即启动被关掉的进程]顶也有分,顶呀...
- 在线等待,请教锁住键盘中指定键的问题
- 在VB中,如何知道表(MyTable)中有无(AAA)列?
- VB写的DLL支不支持内存驻留
- (送分)窗口被移动是触发哪个事件呀?
- toys,你的方法不能用,怎么办
- 创建一个目录后怎么通过程序把权限分配给一个用户?
- 在VB6中如何访问Access2000数据库?
先连接
再用类似DAO的语句
我认为sql server最大的优势在
可以用存储过程
你要好好学习一下哦
Public DBMain40 As New ADODB.Connection
public ADO_Mast As New ADODB.Recordset
'以上是全局變量
'
Private Sub Form_Load()
sConn = Provider=SQLOLEDB.1;Persist Security Info=True;User
ID=sa;Initial Catalog=Northwind;Data Source=PWW DBMain40.Open sConn
call Query
End Sub
Private Sub Query()
sRstSource = "Select ID As 部门代号,NAME As 部门名称,Descs As 部门说
明,BIG,WORK From EMPTYPE order by ID "
If ADO_Mast.State Then
ADO_Mast.Close
End If
ADO_Mast.CursorType = adOpenKeyset
ADO_Mast.CursorLocation = adUseClient
ADO_Mast.LockType = adLockPessimistic
ADO_Mast.Open sRstSource, DBMain40
Set DGD_Detail.DataSource = ADO_Mast
End Sub
cnn1.ConnectionString = "driver={SQL Server};" & _
"server=server;uid=userer;pwd=12345;database=xxx"
'server 为:SqlServer名称
'uid为:Sql用户名
'pwd为:用户口令
'database为:数据库名
cnn1.ConnectionTimeout = 30
cnn1.CursorLocation = adUseClient
cnn1.Open
2、打开connection
3、传递查询语句给command对象,
4、返回纪录给Recordset对象
5、关闭connection
Dim Rs As New ADODB.Recordset
CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=northwind;User Id=sa;Password=sa;"
CN.Open
Rs.CursorLocation = adUseClient
Rs.Open "select * from employees", CN, adOpenDynamic, adLockBatchOptimistic
Set MSHFlexGrid1.DataSource = Rs
Dim Rs As New ADODB.Recordset
CN.ConnectionString = "Provider=sqloledb;Data Source=pmserver;Initial Catalog=northwind;User Id=sa;Password=sa;"
CN.Open
Rs.CursorLocation = adUseClient
Rs.Open "select * from employees", CN, adOpenDynamic, adLockBatchOptimistic
Do Until Rs.EOF
Combo1.AddItem Rs.Fields("FirstName")
Rs.MoveNext
Loop
CN.Close
www.dapha.net
www.21code.com
www.vbeden.com
www.myvc.net
msdn.microsoft.com和MSDN得到更多的帮助.............