110,566
社区成员
发帖
与我相关
我的任务
分享
try{
OleDbServerDAL.DbHelperOleDb.RunProcedure("DATAIMPORT");
}
catch (Exception ex)
{
SystemLog.WriteLog(ex.Message);
}
/// <summary>
/// 执行存储过程--不带参数执行存储过程
/// </summary>
/// <param name="storedProcName">存储过程名</param>
/// <returns>DataSet</returns>
public static void RunProcedure(string storedProcName)
{
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
connection.Open();
OleDbCommand command = connection.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = storedProcName;
command.ExecuteNonQuery();
connection.Close();
}
}