public void DbDelete(DbConnection myDbCon) { string DeleteCommand = ""; DeleteCommand = "DELETE MOVIE_MAKERS WHERE ID = @pId "; //Debug.Print(InsertCommand); SqlParameter[] sqlparams = new SqlParameter[1]; // ID sqlparams[0] = new SqlParameter("@pId", SqlDbType.Int); sqlparams[0].Value = Id; myDbCon.SetParameter(sqlparams); // DELETE文の実行 int cnt = myDbCon.execSqlCommand(DeleteCommand); if (cnt == 0) throw new Exception("ID[" + Id + "]の削除対象のデータが存在しません"); }
public void DatabaseExport() { DbConnection dbcon = new DbConnection(); // データベースへ登録 string sqlCommand = "INSERT INTO MOVIE_FILES (NAME, SIZE, FILE_DATE, LABEL, SELL_DATE, PRODUCT_NUMBER, FILE_COUNT, EXTENSION) VALUES( @pName, @pSize, @pFileDate, @pLabel, @pSellDate, @pProductNumber, @pFileCount, @pExtension )"; SqlCommand command = new SqlCommand(sqlCommand, dbcon.getSqlConnection()); SqlParameter[] sqlparams = new SqlParameter[8]; // Create and append the parameters for the Update command. sqlparams[0] = new SqlParameter("@pName", SqlDbType.VarChar); sqlparams[0].Value = DatabaseMovieFile.Name; sqlparams[1] = new SqlParameter("@pSize", SqlDbType.Decimal); sqlparams[1].Value = DatabaseMovieFile.Size; sqlparams[2] = new SqlParameter("@pFileDate", SqlDbType.DateTime); sqlparams[2].Value = DatabaseMovieFile.FileDate; sqlparams[3] = new SqlParameter("@pLabel", SqlDbType.VarChar); sqlparams[3].Value = LabelPath; sqlparams[4] = new SqlParameter("@pSellDate", SqlDbType.DateTime); if (DatabaseMovieFile.SellDate.Year >= 2000) sqlparams[4].Value = DatabaseMovieFile.SellDate; else sqlparams[4].Value = Convert.DBNull; sqlparams[5] = new SqlParameter("@pProductNumber", SqlDbType.VarChar); sqlparams[5].Value = DatabaseMovieFile.ProductNumber; sqlparams[6] = new SqlParameter("@pFileCount", SqlDbType.Int); sqlparams[6].Value = DatabaseMovieFile.FileCount; sqlparams[7] = new SqlParameter("@pExtension", SqlDbType.VarChar); sqlparams[7].Value = DatabaseMovieFile.Extension; dbcon.SetParameter(sqlparams); dbcon.execSqlCommand(sqlCommand); }