Type a page name and press Enter. You'll jump to the page if it exists, or you can create it if it doesn't.
To create a page in a module other than msi, prefix the name with the module name and a period.
MsiRecordSetString (msi)
.
C# Signature:
[DllImport("msi.dll", CharSet=CharSet.Unicode)]
static extern int MsiRecordSetString(IntPtr hRecord, int iField, string szValue);
Notes:
None.
Tips & Tricks:
Please add some!
Sample Code:
* The sample application below demonstrates how to use MsiRecordSetString and several other MSI APIs in C#
* to modify a property value in an MSI database. To run it, simply create a new Windows Console application
* and replace the code that Visual Studio gives you with the code below. You may have to modify the namespace name.
* The sample as-is requires a valid MSI database named SETUP.msi, with a property named PROPERTY1 in the Property
* table, to be located in C:\. You can of course change the path to your MSI database in the calls to ChangeMSIProperty()
public class MsiInstallationSupportException : ApplicationException
{
// This class encapsulates and overloads exception handling.
public MsiInstallationSupportException() : base() { }
public MsiInstallationSupportException(string message, Exception innerException) : base(message, innerException) { }
public MsiInstallationSupportException(string message) : base(message) { }
}
[DllImport("msi.dll", CharSet = CharSet.Unicode)]
static extern int MsiDatabaseCommit(IntPtr hDatabase);
[DllImport("msi.dll", CharSet = CharSet.Unicode)]
static extern int MsiRecordSetString(IntPtr hRecord, int iField, string szValue);
[DllImport("msi.dll")]
static extern int MsiViewClose(IntPtr viewhandle);
// Open mode constants for MsiOpenDatabase.
const int MSIDBOPEN_READONLY = 0; // database open read-only, no persistent changes
const int MSIDBOPEN_TRANSACT = 1; // database read/write in transaction mode
const int MSIDBOPEN_DIRECT = 2; // database direct read/write without transaction
const int MSIDBOPEN_CREATE = 3; // create new database, transact mode read/write
const int MSIDBOPEN_CREATEDIRECT = 4; // create new database, direct mode read/write
// Program entry point.
static void Main(string[] args)
{
ChangeMSIProperty(@"C:\SETUP.msi", "PROPERTY1", "1"); // Set property "PROPERTY1" to a value of 1.
ChangeMSIProperty(@"C:\SETUP.msi", "PROPERTY1", "0"); // Now set property "PROPERTY1" to a value of 1.
}
// The method to call to set/change a property value.
static void ChangeMSIProperty(string path, string property, string value)
{
// The sql command. Note the "?" placeholder for the value.
string sql = @"UPDATE Property SET Value = ? WHERE Property = '" + property + "'";
IntPtr msiHandle = IntPtr.Zero;
IntPtr msiRecord = IntPtr.Zero;
IntPtr msiView = IntPtr.Zero;
int iOpenMode = MSIDBOPEN_DIRECT;
IntPtr persist = new IntPtr(iOpenMode);
try
{
// Open the database for read/write access.
WINDOWS_MESSAGE_CODES returnValue = (WINDOWS_MESSAGE_CODES)MsiOpenDatabase(path, persist, out msiHandle);
if (returnValue != WINDOWS_MESSAGE_CODES.ERROR_SUCCESS)
throw new MsiInstallationSupportException(string.Format(CultureInfo.InvariantCulture, "MsiOpenDatabase returned error code {0}.", returnValue.ToString()));
// If the returnValue error code is defined in the enum WINDOWS_MESSAGE_CODES, the exception message will show the enum code name; otherwise it will show the error number.
// Create a record to be used in tandem with the view below.
msiRecord = MsiCreateRecord(1);
if (msiHandle == IntPtr.Zero)
throw new MsiInstallationSupportException(string.Format(CultureInfo.InvariantCulture, "MsiCreateRecord failed to return a valid record handle."));
// Set field 1 of your record to the value to set in the database.
returnValue = (WINDOWS_MESSAGE_CODES)MsiRecordSetString(msiRecord, (int)1, value);
if (returnValue != WINDOWS_MESSAGE_CODES.ERROR_SUCCESS)
throw new MsiInstallationSupportException(string.Format(CultureInfo.InvariantCulture, "MsiRecordSetString returned error code {0}.", returnValue.ToString()));
// Open a view to use to apply the change. Here's where you specify your sql command.
returnValue = (WINDOWS_MESSAGE_CODES)MsiDatabaseOpenViewW(msiHandle, sql, out msiView);
if (returnValue != WINDOWS_MESSAGE_CODES.ERROR_SUCCESS)
throw new MsiInstallationSupportException(string.Format(CultureInfo.InvariantCulture, "MsiDatabaseOpenViewW returned error code {0}.", returnValue.ToString()));
// Execute the view, passing it the record set. If the property does not exist, it will NOT be created and there will be NO error thrown.
returnValue = (WINDOWS_MESSAGE_CODES)MsiViewExecute(msiView, msiRecord);
if (returnValue != WINDOWS_MESSAGE_CODES.ERROR_SUCCESS)
throw new MsiInstallationSupportException(string.Format(CultureInfo.InvariantCulture, "MsiViewExecute returned error code {0}.", returnValue.ToString()));
// Close the view.
returnValue = (WINDOWS_MESSAGE_CODES)MsiViewClose(msiView);
if (returnValue != WINDOWS_MESSAGE_CODES.ERROR_SUCCESS)
{
// Commit the changes.
returnValue = (WINDOWS_MESSAGE_CODES)MsiDatabaseCommit(msiHandle);
if (returnValue != WINDOWS_MESSAGE_CODES.ERROR_SUCCESS)
throw new MsiInstallationSupportException(string.Format(CultureInfo.InvariantCulture, "MsiDatabaseCommit returned error code {0}.", returnValue.ToString()));
}
else
{
// Failed to close the view.
if (returnValue != WINDOWS_MESSAGE_CODES.ERROR_SUCCESS)
throw new MsiInstallationSupportException(string.Format(CultureInfo.InvariantCulture, "MsiViewClose returned error code {0}.", returnValue.ToString()));
}
}
finally
{
// Close handles or you could get a corrupted database and un-closed handles.
if (msiRecord != IntPtr.Zero)
MsiCloseHandle(msiRecord);
if (msiView != IntPtr.Zero)
MsiCloseHandle(msiView);
if (msiHandle != IntPtr.Zero)
MsiCloseHandle(msiHandle);
}
}
}
helpful tips or sample code to share for using this API in managed code?
corrections to the existing content?
variations of the signature you want to share?
additional languages you want to include?
Select "Edit This Page" on the right hand toolbar and edit it! Or add new pages containing supporting types needed for this API (structures, delegates, and more).
Revisions