[WiX-users] How to use Property for User Interface

[Abhishek,HiRePro <abh...@hi...>]

Hi,

 

I am new to WiX and want to know How to set the Property......

I Actually want to create a database through wix.. For that I need to get
information from the user and store it in a property value...

 

Please Help

 

And using that value I need to create database..

I want to accept 3 things from the user

1.ServerName

2.UserName and 

3.Password

 

 

I have the code as below...please help me to create database.....

 

 

<Wix xmlns="http://schemas.microsoft.com/wix/2003/01/wi">

  <Product Name="TestDB" Id="{A4189B2F-8C90-4bbd-A850-644B76AB8B96}"
Language="1033" Codepage="1252" Version="1.0.0" Manufacturer="Abhishek">

    

    <Package Id="????????-????-????-????-????????????" Keywords="Installer"
Description="Acme's Foobar 1.0 Installer" Comments="Foobar is a registered
trademark of Acme Ltd." Manufacturer="Acme Ltd." InstallerVersion="100"
Languages="1033" Compressed="yes" SummaryCodepage="1252" />

    <Media Id="1" Cabinet="Sample.cab" EmbedCab="yes" DiskPrompt="CD-ROM #1"
/>

    

    <Property Id="DiskPrompt" Value="Property123" />

    <User Id="SQLUser" Name="[uname]" Password="[pwd]" />

    <Directory Id="TARGETDIR" Name="SourceDir">

      <Directory Id="ProgramFilesFolder" Name="PFiles">

        <Directory Id="InstallDir" Name="Acme">

          <Component Id="SqlComponent"
Guid="{A4189B2F-8C90-4bbd-A850-644B76AB8B96}">

            <SqlDatabase Id="SqlDatabase" Database="AbhiSQL" User="SQLUser"
Server="[sname]" CreateOnInstall="yes" DropOnUninstall="yes"
ContinueOnError="yes">

              <SqlScript Id="CreateTable" BinaryKey="CreateTable"
ExecuteOnInstall="no" />

            </SqlDatabase>

          </Component>

        </Directory>

      </Directory>

    </Directory>

    <Binary Id="CreateTable" SourceFile="CreateTable.sql" />

    <Feature Id="SqlFeature" Title="SqlFeature" Level="1">

      <ComponentRef Id="SqlComponent" />

    </Feature>

    <Property Id="SQLSERVER">[sname]</Property>

    <Property Id="SQLUSER">[uname]</Property>

    <Property Id="SQLPASSWORD">[pwd]</Property>

    <UI>

      <Property Id="DefaultUIFont">DlgFont8</Property>

      <Dialog Id="CustomizeDlg" Width="370" Height="270"
Title="[ProductName] [Setup]" NoMinimize="yes" TrackDiskSpace="yes">

        <Control Id="Tree" Type="SelectionTree" X="25" Y="85" Width="175"
Height="95" Property="_BrowseProperty" Sunken="yes" TabSkip="no" Text="Tree
of selections" />

        <Control Id="Browse" Type="PushButton" X="304" Y="200" Width="56"
Height="17" Text="[ButtonText_Browse]">

          <Publish Event="SelectionBrowse" Value="BrowseDlg">1</Publish>

 

.............

...........

...........

 

 

<Dialog Id="DBDetails" Width="370" Height="270" Title="[ProductName]
[Setup]">

        <Control Id="Next" Type="PushButton" X="236" Y="243" Width="56"
Height="17" Default="no" Text="[ButtonText_Next]">

          <Publish Event="NewDialog" Value="ProgressDialog">1</Publish>

        </Control>

        <Control Id="Cancel" Type="PushButton" X="304" Y="243" Width="56"
Height="17" Cancel="no" Text="[ButtonText_Cancel]">

          <Publish Event="SpawnDialog" Value="CancelDlg">1</Publish>

        </Control>

        <Control Id="SName" Type="Text" Height="17" Width="75" X="137"
Y="61" Text="Server Name" />

        <Control Id="uName" Type="Text" Height="17" Width="75" X="137"
Y="98" Text="User Name" />

        <Control Id="pwd1" Type="Text" Height="17" Width="75" X="137"
Y="138" Text="Password" />

       

            

            <Control Id="SN" Type="Edit" Height="15" Width="75" X="236"
Y="61" Property="sname" />

        <Control Id="UserN" Type="Edit" Height="15" Width="75" X="236"
Y="100" Property="uname" />

        <Control Id="PN" Type="Edit" Height="15" Width="75" X="236" Y="138"
Property="pwd" />

        

            <Control Id="SqlText" Type="Text" Height="17" Width="175" X="17"
Y="15" Transparent="yes" NoPrefix="yes">

          <Text>[TitleFont]Enter Valid SQL Authentication Details</Text>

        </Control>

 

.......

......