System.Data.Common.DbCommand.ExecuteNonQuery C# (CSharp) Method

ExecuteNonQuery() public abstract method

public abstract ExecuteNonQuery ( ) : int
return int
        public abstract int ExecuteNonQuery();

Usage Example

コード例 #1
0
        /// <summary>
        /// 上传文件
        /// </summary>
        public void FileUp(string FullName, string DBFullName, byte[] bFile)
        {
            string FileName = System.IO.Path.GetFileName(FullName);
            string CFolder  = System.IO.Path.GetDirectoryName(FullName);
            string DBFolder = System.IO.Path.GetDirectoryName(DBFullName);

            // 1.上传到数据库
            Apq.Data.Common.DbConnectionHelper.Open(Connection);
            System.Data.Common.DbCommand sqlCmd = Connection.CreateCommand();
            sqlCmd.CommandText = "Apq_FileTrans_Insert";
            sqlCmd.CommandType = CommandType.StoredProcedure;
            Apq.Data.Common.DbCommandHelper cmdHelper = new Apq.Data.Common.DbCommandHelper(sqlCmd);
            cmdHelper.AddParameter("@FileName", FileName);
            cmdHelper.AddParameter("@DBFolder", DBFolder);
            cmdHelper.AddParameter("@CFolder", CFolder);
            cmdHelper.AddParameter("@FileStream", bFile);
            cmdHelper.AddParameter("@ID", 0);
            sqlCmd.Parameters["@ID"].Direction = ParameterDirection.InputOutput;
            sqlCmd.ExecuteNonQuery();
            int ID = Apq.Convert.ChangeType <int>(sqlCmd.Parameters["@ID"].Value);

            // 2.转到磁盘
            sqlCmd.Parameters.Clear();
            sqlCmd.CommandText = "Apq_FileTrans_WriteToHD_ADO";
            sqlCmd.CommandType = CommandType.StoredProcedure;
            cmdHelper.AddParameter("@ID", ID);
            cmdHelper.AddParameter("@KeepInDB", DBNull.Value);
            sqlCmd.ExecuteNonQuery();
        }
All Usage Examples Of System.Data.Common.DbCommand::ExecuteNonQuery