我是vb初学者,最好有代码!!谢了!
解决方案 »
- 我用matlab制作的DLL组件在vb中调用,出现错误后在vc调试器中指向出错语句,请懂汇编语言的大虾进来指点
- 请问如何让HTML和WORD另寸为TXT
- 为了在记录集中找到是否有相同的数据,我做了个双重循环但速度太慢,对于几千条数据来说会死掉谁能想出简洁的办法(100分在线)
- 关于数据类型byte()
- 弱弱地问一个菜鸟问题:对两个数据表进行关联,是不是一定要用到DataEnvironment?如果我是用ADO打开的数据库怎么办?
- 用winsock控件。客户机给服务器提出连接请求,但服务器端的软件没有运行。怎么给出提示?
- 如何把从组件中取的记录集赋给SPread?
- VB6中如何检查自定义数据类型数组的元素个数(在线等待)
- 最简单的问题
- 感谢高手指点,如何用VB做一个桌面透明图象???
- 谁能告诉我怎样用iNET控件执行简单的FTP文件的上传和下载?
- 窗体Resize事件问题
PLSQL?不懂就要顶楼主说清楚
添加和显示的都有
Option Explicit
Private mConn As ConnectionPrivate Sub Command1_Click()
Dim rs As ADODB.Recordset
Dim cmd As ADODB.Command
Dim param As ADODB.Parameter
Set cmd = New ADODB.Command
cmd.ActiveConnection = mConn
cmd.CommandText = "insert_users"
cmd.CommandType = adCmdStoredProc
Set param = cmd.CreateParameter("truename", adChar, adParamInput, 20, Trim(txttruename.Text))
cmd.Parameters.Append param
Set param = cmd.CreateParameter("regname", adChar, adParamInput, 20, Trim(txtregname.Text))
cmd.Parameters.Append param
Set param = cmd.CreateParameter("pwd", adChar, adParamInput, 20, Trim(txtpwd.Text))
cmd.Parameters.Append param
Set param = cmd.CreateParameter("sex", adChar, adParamInput, 20, Trim(txtsex.Text))
cmd.Parameters.Append param
Set param = cmd.CreateParameter("email", adChar, adParamInput, 20, Trim(txtemail.Text))
cmd.Parameters.Append param
Dim s As Single
s = Val(Format(Text1.Text, "Fixed"))
Set param = cmd.CreateParameter("sl", adSingle, adParamInput, 50, s)
cmd.Parameters.Append param
Set rs = cmd.Execute
' Cmd_Tjjl.Parameters("@zwrq") = Format(Zwrq.Value, "yyyy-mm-dd")
' Cmd_Tjjl.Parameters("@zh") = Zh.Text
' .....
' Cmd_Tjjl.Parameters("@bz2") = Bz2.Text
'Cmd_Tjjl.Parameters("@czy")='11'
Command2_Click
End SubPrivate Sub Command2_Click()
Dim rs As ADODB.Recordset
Dim cmd As ADODB.Command
Dim param As ADODB.Parameter
Set rs = New ADODB.Recordset
Set cmd = New ADODB.Command
cmd.ActiveConnection = mConn
cmd.CommandText = "select_users"
cmd.CommandType = adCmdStoredProc
mConn.CursorLocation = adUseClient '设置为客户端 Set rs = cmd.Execute() MsgBox rs.RecordCount
Set DataGrid1.DataSource = rs
DataGrid1.RefreshEnd Sub
Private Sub Form_Load()
'open the connection
Set mConn = New Connection
mConn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Test;Data Source=yang"
mConn.Open
Dim rs As New ADODB.Recordset
Set rs = New ADODB.Recordset
rs.Open "users", mConn, adOpenStatic, adLockPessimistic
' MsgBox rs.RecordCountEnd SubPrivate Sub Form_Unload(Cancel As Integer) mConn.Close
Set mConn = Nothing
End Sub
存储过程
CREATE PROCEDURE insert_users @truename char(20), @regname char(20),@pwd char(20),@sex char(20),@email char(20),@sl decimal(19,2)
AS
insert into users(truename,regname,pwd,sex,email,sl) values(@truename,@regname,@pwd,@sex,@email,@sl)
GOCREATE PROCEDURE select_users
AS
select * from users
GO
呵呵
strcon = "Provider=SQLOLEDB.1;Password=....
gcon.ConnectionString = strcon
gcon.Open
Private Sub Form_Load()
Call getAllComp(lvC)
End Sub
Public Sub getAllComp(lv As ListView)
Dim rs As Recordset
Dim i As Integer
Dim Item As ListItem
i = 1
lv.ListItems.Clear
Dim txtsql As String
txtsql = "exec pr_getallcompanies"
Set rs = gcon.Execute(txtsql)
'if gcompany.GetAllCompanies(rs) Then
Do While Not rs.EOF
Set Item = lv.ListItems.Add(, , i)
Item.ListSubItems.Add , , rs!companyid
Item.ListSubItems.Add , , rs!companycode
Item.ListSubItems.Add , , rs!CompanyName
rs.MoveNext
i = i + 1
Loop
End Sub'pr_getallcompanies--存储过程
online的是从另外角度写的存储过程,哈哈