求助:单击按钮调用存储过程
我在SQL2005创建了个存储过程,想通过单击按钮,运行存储过程,但存储过程好像没被执行,EXCEL里的数据没有导入到表中,请帮忙看下,谢谢各位!
存储过程是:
USE [TEST]
GO
/****** 对象: StoredProcedure [dbo].[Add_USER] 脚本日期: 10/29/2009 14:55:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[Add_USER] AS
Begin
begin tran
DELETE FROM [TEST].[dbo].[sheet1$]
insert into [TEST].[dbo].[sheet1$] (USR_ID,USR_DEPT,USR_DES,USR_STU)
SELECT USR_ID ,LEFT(USR_DEPT,10),USR_DES,USR_STU FROM
OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source="G:\EMP\employee.xls"; user id =admin;password=;Extended Properties="Excel 8.0;IMEX=1;"')...[employee$]
if @@error<>0
begin
ROLLBACK TRAN
return --出错时,要回滚事务并退出处理,否则一样会执行后面的语句
End
commit tran
End
按钮单击事件
private void calbut_Click(object sender, System.EventArgs e)
{
string conn = "SERVER=198.72.123.101;database=TEST;uid=TEST;password=TEST;";
objSqlConnection = new SqlConnection(conn);
objSqlConnection.Open();
objSqlCommand = new SqlCommand("Add_USER", objSqlConnection);
objSqlCommand.CommandType=CommandType.StoredProcedure;
objSqlCommand.CommandTimeout=600;
}