Comments by Mohan Subramani

Mohan Subramani 11-Sep-14 1:37am View

I got the tips from msdn link, to do SELECT in a MSI database.
(Am using below code to SELECT a Feature named Complete)

View = database.OpenView("SELECT `Feature`.`Feature` FROM `Feature` WHERE `Feature`.`Feature`= 'Complete'")
View.Execute()
database.commit()

fetchDB = View.fetch()
MessageBox.Show(fetchDB)

If (fetchDB = "") Then
MessageBox.Show("This Database doesnt contain Feature 'COMPLETE'")
End If

i get error in the line "MessageBox.Show(fetchDB)" -- Am not able to convert _COMobject ot String
How can i convert the fetch data from dtabase to string to Check whether it is Null or not

Error:

Invalid CaseException was handled.
Conversion from type '_ComObject' to type 'String' is not valid.

Please assist

Mohan Subramani 10-Sep-14 8:42am View

Thanks for your reply,
I have gone through the documentation. I will use SELECT and INSERT commands seperatly.
I have a question here,
Can i get value of the executing SELECT statement in a binary 1 or Zero value.
For e.g
SQLquery = "SELECT * FROM database WHERE `Feature` = 'Complete'"
View = database.OpenView(SQLquery) ---> This statement to give values 1 if YES, 0 is No

So that i can execute my next INSERT command accordingly ?

Mohan Subramani 8-Sep-14 16:31pm View

thank you sir.

Mohan Subramani 2-Sep-14 12:46pm View

Sorry guys, for the incomplete question.
"COMException was unhandled
ApplyTransform, TransformFile,ErrorConditions"

for the line "instDb.ApplyTransform(MSTpath, MsiTransformError.msiTransformErrorViewTransform);"

Mohan Subramani 29-Jun-14 5:41am View

Not able to post my XML code here .. replacing < > with ? ?

?configuration?

?configSections?
?sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System.Version=2.0.0.0, Culture=neutral, PublicToken=b77a5c5619348089"?

?section name="Timer.Properties.Settings" type="System.Configuration.ApplicationSettingsGroup, System.Version=2.0.0.0, Culture=neutral, PublicToken=b77a5c5619348089" requirePermission="false"/?
?/sectionGroup?
?/configSections?

?applicationSettings?
?Timer.Properties.Settings?
?settings name="DefaultTimer" serializeAs="String"?
?value?90?/value?
?/settings?

?/Timer.Properties.Settings?
?/applicationSettings?
?startup?
?supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" /?
?/startup?
?/configuration?

Mohan Subramani 6-Jun-14 0:08am View

Manikandan,

Thanks for your reply

Am reading the HKCU registry hive using the below code,

private void button3_Click(object sender, EventArgs e)
{
FileInfo msiFile = new FileInfo(@"C:\temp\WinInstaller\Sample.msi");
WindowsInstaller.Installer inst = (WindowsInstaller.Installer)new Installer();
Database instDb = inst.OpenDatabase(msiFile.FullName, WindowsInstaller.MsiOpenDatabaseMode.msiOpenDatabaseModeTransact);
WindowsInstaller.View view = instDb.OpenView("SELECT `Registry`.`Key`, `Registry`.`Name`, `Registry`.`Value` FROM `Registry` WHERE `Registry`.`Root`=1 ORDER BY `Registry`.`Root`");
view.Execute(null);

Here, Root value '1' refers to the HKCU registry hive,

Registry (s72) Root (i2) Name (L255) Value (L0)
69ADA5050611 1 PATH C:\Program Files\Sample\

I want to export all the read HKCU registry Key values into a valid .reg file which i can save it on my local drive,
Am lost in which logic i need to follow,

Comments by Mohan Subramani (Top 6 by date)