我的程序想实现,在本地access数据库中记录传到服务器中的sql数据库中的表1中,实现如果表1中存在相同“单位名称”和“季度”的记录(多条)那么就提示“是否覆盖”,如果覆盖就删除已存在的记录,传入新记录。如果表1中不存在,那么就直接导入新记录,程序如下:If Trim(Text1.Text) <> "" Or Trim(Combo1.Text) <> "" Then
Dim cn As New ADODB.Connection
Dim confirm As Integer
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;pwd=sa;Initial Catalog=SSt;Data Source=127.0.0.1"
cn.CursorLocation = adUseClient
cn.Open
rs.Open "select * from 表1 where 单位名称='" & Trim(Text1.Text) & "' and 季度='" & Trim(Combo1.Text) & "' ", cn, , adCmdTable
If rs.RecordCount > 0 Then
confirm = MsgBox("此单位本季度信息已存在,是否覆盖", 1, "提示信息")
If confirm = 1 Then
rs.Close
rs.Open "delete from 表1 where 单位名称='" & Trim(Text1.Text) & "' and 季度='" & Trim(Combo1.Text) & "' ", cn, , adCmdTable
后面的不知道怎么写了,大家帮帮忙。谢谢!
Dim cn As New ADODB.Connection
Dim confirm As Integer
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;pwd=sa;Initial Catalog=SSt;Data Source=127.0.0.1"
cn.CursorLocation = adUseClient
cn.Open
rs.Open "select * from 表1 where 单位名称='" & Trim(Text1.Text) & "' and 季度='" & Trim(Combo1.Text) & "' ", cn, , adCmdTable
If rs.RecordCount > 0 Then
confirm = MsgBox("此单位本季度信息已存在,是否覆盖", 1, "提示信息")
If confirm = 1 Then
rs.Close
rs.Open "delete from 表1 where 单位名称='" & Trim(Text1.Text) & "' and 季度='" & Trim(Combo1.Text) & "' ", cn, , adCmdTable
后面的不知道怎么写了,大家帮帮忙。谢谢!
解决方案 »
- vb 数据库查询
- msflexgrid的默认选中问题
- 关于ADO中事务的问题,请教高手。
- Help~ 如何注销 ActiveX exe 程序?(之前用 pro1.exe /reg来注册)
- 网络计费,给指导一下吧,多谢多谢!
- 我的系统中有两个操作系统2000及98,每次开机都出现选择提示(30秒),如何删除98系统的选项,只剩下2000,以后进入系统就不必选择了?
- 安装程序还未搞定!在2000下可正常安装,在98是遇到问题停止安装,请各位好心人再帮一下!100分!在线等!
- ::::::::用VB对XML这样操作,能行吗?请高手指教,在线等候,急 急 急 !!!!!
- 如何得到treeview中被选中的node的key?
- 数据库的初学问题
- 什么情况下用listview,什么情况下用msflexgrid呀?
- 在线求教vb如何调用oracle 10g中的存储过程!急!!
SELECT 单位名称,季度,考核标准,考核分数,自评分
FROM Acs表
WHERE 单位名称='" & Trim(Text1.Text) & "' and 季度='" & Trim(Combo1.Text) & "'"
IF 存在,則彈出對話框,是否覆盖
ELSE
插入記錄
Dim cn As New ADODB.Connection
Dim confirm As Integer
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;pwd=sa;Initial Catalog=SSt;Data Source=127.0.0.1"
cn.CursorLocation = adUseClient
cn.Open
rs.Open "select * from 表1 where 单位名称='" & Trim(Text1.Text) & "' and 季度='" & Trim(Combo1.Text) & "' ", cn, , adCmdTable
If rs.RecordCount > 0 Then
confirm = MsgBox("此单位本季度信息已存在,是否覆盖", 1, "提示信息")
If confirm = 1 Then
rs.Close
rs.Open "delete from 表1 where 单位名称='" & Trim(Text1.Text) & "' and 季度='" & Trim(Combo1.Text) & "' ", cn, , adCmdTable
cn.Execute ("insert into Sql表(单位代码,标准分,不符合项数,企业备注,季度) SELECT 单位代码,标准分,不符合项数,企业备注,季度 FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source=" & App.Path & "\ccs.mdb;access表')")
Dim cn As New ADODB.Connection
Dim confirm As Integer
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;pwd=sa;Initial Catalog=SSt;Data Source=127.0.0.1"
cn.CursorLocation = adUseClient
cn.Open
rs.Open "select * from 表1 where 单位名称='" & Trim(Text1.Text) & "' and 季度='" & Trim(Combo1.Text) & "' ", cn, , adCmdTable
If Not rs.EOF Then
confirm = MsgBox("此单位本季度信息已存在,是否覆盖", 1, "提示信息")
If confirm = 1 Then
rs.Delete
rs.Close
Else
rs.close
exit sub
End If
End If
cn.Execute ("insert into 表1 SELECT 单位代码,标准分,不符合项数,企业备注,季度 FROM 表1 in "" & App.Path & "\ccs.mdb""")End If