现在有一个关于VB中用SQL insert语句问题,请大家帮个忙
语句我简化了如下
strcn = "Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=base;Data Source=space"
cnn.ConnectionString = strcn
cnn.Open
sql = "insert into maindisplay (telnum,work) values ('3333','23-1')" '就是这句
cnn.Execute (sql)
ado1.Refresh
cnn.Close这句我是强制输入数据。在企业管理器中可以成功输入,在VB中输入失败。我用ado1.RecordSource这个方法也是不行,请大家赐教
语句我简化了如下
strcn = "Provider=SQLOLEDB.1;Password=sa;Persist Security Info=True;User ID=sa;Initial Catalog=base;Data Source=space"
cnn.ConnectionString = strcn
cnn.Open
sql = "insert into maindisplay (telnum,work) values ('3333','23-1')" '就是这句
cnn.Execute (sql)
ado1.Refresh
cnn.Close这句我是强制输入数据。在企业管理器中可以成功输入,在VB中输入失败。我用ado1.RecordSource这个方法也是不行,请大家赐教
解决方案 »
- VB如何使用淘宝API
- 为升级为高级群散分-好人终于得到了回报
- 在用ado调用access,出现-2147217887错误
- VB ADO 问题
- imageButton 我的VB6,工具箱里没有ImageButton,请问它在那里个OCX文件里。
- 怎么用winsock循环发送,客户端也能一个个循环接收?
- 谁有检测网页相似度的代码,求救!
- 急急急,非常急!一个考试系统,帮帮忙,各位高手!
- 有一个字段‘职称’,值为:初级,中级,高级,怎么样在查找时使记录按职称的升序(初、中、高)或降序(高、中、初)排列??(解决完马
- 请问高手们有知道VB反编译的吗???
- VB 如何做打印控制?
- 关于VB控制驱动类问题
"对象关闭时无法进行操作",去掉" cnn.Close"这一行试一下
要在工程--引用 Microsoft ActiveX Data Objects 2.5 Library,并定义cnn
Dim cnn As New ADODB.Connection
sql = "insert into maindisplay (telnum,work) values ('3333','23-1')" '就是这句
cnn.Execute (sql)用ADODC:要添加ADODC1
1)错误的做法:
sql = "insert into maindisplay (telnum,work) values ('3333','23-1')" '就是这句
ado1.RecordSource = sql '会出现对象关闭时无法...
ado1.Refresh
2)正确的做法:
sql = "insert into maindisplay (telnum,work) values ('3333','23-1')" '就是这句
Adodc1.Recordset.ActiveConnection.Execute = sql
ado1.Refresh
要在工程--引用 Microsoft ActiveX Data Objects 2.5 Library,并定义cnn
Dim cnn As New ADODB.Connection
sql = "insert into maindisplay (telnum,work) values ('3333','23-1')" '就是这句
cnn.Execute (sql)
如果已经用 ADODC 连接了数据库,则不需要额外的连接对象:ado1.Recordset.ActiveConnection.Execute "insert into maindisplay(telnum,work) values('3333','23-1')"ado1.Requery
On Error GoTo errOpenBDConnection:
sSQL = "Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=" + Trim(PUserName) + ";Password=" + Trim(PUserPassword) + ";Data Source=" + Trim(PUserDbName)
ConnString = sSQL 'Save the Public connection string.
Conn.Open sSQL
'MsgBox ("Database connection successful!"), vbInformation, "EnterpriseIQ System"
frmLoginByUsers.Show
Exit Function
errOpenBDConnection:
MsgBox ("Database connection failed!" & vbCrLf & Err.Number & Err.Number & vbCrLf & Err.Description), vbCritical, " EnterpriseIQ System"
Exit Function
End FunctionPublic Function NewChangeSave()
Dim SaveSql As String
Dim SaveCommand As New command
On Error GoTo eNext: SaveSql = "insert into iqms.ia_002_tabmodulespowerchange" + _
"(id, serialnumber, b_pamx, a_pamx,c_user,c_date,c_reason) Values" + _
"(S_IA_002_TABMODULESPOWERCHANGE.NEXTVAL,'" + Trim(strModulesSn) + "'," + Trim(douBPamxValue) + "," + Trim(txtChangedPower) + "," + _
"'" + Trim(txtChangeUser) + "',TO_DATE('" + Format(txtChangeDate, "yyyy-mm-dd hh:mm:ss") + "', 'YYYY-MM-DD HH24:MI:SS'),'" + _
Trim(txtChangeReason) + "')"
SaveCommand.ActiveConnection = Conn
SaveCommand.CommandType = adCmdText
SaveCommand.CommandText = SaveSql
SaveCommand.Execute
Exit Function
eNext:
MsgBox Err.Description, vbCritical, Err.Number
End Function