Database

<br />
<br />
'THIS IS THE CODE INSIDE AN ASPX FILE<br />
<br />
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"   ConnectionString="<%$ ConnectionStrings:HolidayDBConnectionString %>"        <br />
            InsertCommand='StoredProcedure1' <br />
            <br />
            <br />
            SelectCommand="SELECT DISTINCT [ActivityName] FROM [Activities] ORDER BY [ActivityName]" <br />
            InsertCommandType="StoredProcedure"><br />
            <InsertParameters><br />
                <asp:Parameter Name="GetActivityName" Type="String" /><br />
            </InsertParameters><br />
        </asp:SqlDataSource><br />
<br />

<br />
'HERE IS THE STORED PROCEDURE<br />
<br />
ALTER PROCEDURE dbo.StoredProcedure1	<br />
	(<br />
	@GetActivityName nvarchar(50)<br />
	)	<br />
AS<br />
<br />
<br />
        INSERT INTO Activities VALUES (@GetActivityName)<br />
<br />
<br />
	RETURN<br />
<br />

<br />
<br />
'HERE IS THE TABLE DEFINITION<br />
<br />
[PK] ActivityNumber bigint (IDENTITY COLUM) ALLOW NULLS FALSE<br />
     ActivityName  nvarchar(50) ALLOW NULLS FALSE<br />
<br />
<br />

function SQLServerExpress2005Exist(): Boolean;
begin  
  Result := True;
  try
    SQLServer := CreateOleObject('SQLDMO.SQLServer');
  except
    if MsgBox(CustomMessage('SQLServerExpress2005Msg'), mbConfirmation, MB_YESNO or MB_DEFBUTTON2) = IDYES then Result := False;
  end;
end;