Ok I worked it out!!! Went down to the library and borrowed a book (not done that in
a long time [=)]). By wrox Beginning Dynamic Website with ASP.NET Web Matrix...

I found in there the following code and put my own values into it...
<h6>

    Function GetDesignDetails(ByVal designId As Integer) As System.Data.DataSet
        Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\Inetpub\vhosts\davejenkins.co.uk\httpdoc s\admin\sitedb.mdb"
        Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString )

        Dim queryString As String = "SELECT [tblDesigns].[SiteUrl], [tblDesigns].[DesignId], [tblDesigns].[SiteLongDes"& _
"c], [tblDesigns].[SiteOwner], [tblDesigns].[SiteTech], [tblDesigns].[SiteImage],"& _
" [tblDesigns].[AltTag], [tblDesigns].[SiteCreated], [tblDesigns].[SiteThumb] FRO"& _
"M [tblDesigns] WHERE ([tblDesigns].[DesignId] = @DesignId)"
        Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand
        dbCommand.CommandText = queryString
        dbCommand.Connection = dbConnection

        Dim dbParam_designId As System.Data.IDataParameter = New System.Data.OleDb.OleDbParameter
        dbParam_designId.ParameterName = "@DesignId"
        dbParam_designId.Value = designId
        dbParam_designId.DbType = System.Data.DbType.Int32
        dbCommand.Parameters.Add(dbParam_designId)

        Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter
        dataAdapter.SelectCommand = dbCommand
        Dim dataSet As System.Data.DataSet = New System.Data.DataSet
        dataAdapter.Fill(dataSet)

        Return dataSet
    End Function

 Sub Page_load()
        If Not Page.IsPostBack Then
        viewSite.DataSource = GetDesignDetails(Request.Querystring.Item("designI d"))
        viewSite.DataBind()
        End If
 End Sub
</h6>

Sorry if this sounds stupid, the above seems a lot simpler... why do it the other
way and is that the normal way of doing it?

Thanks


David Jenkins
-------------------------------------------------------------
Do you want to make extra money around your commitments?
Credit cards, bills, loans and a mortgage - all getting you down?
Is your pension going to be enough when you retire?
There is a solution visit http://www.1stmillion.co.uk
or call 01772 489521

Either way is fine. It comes down to the way you build the query. The book's example uses a parameterized query which I'd recommend over the other method. Using parameterized queries give you a certainly level of safety that you don't get from building the whole query. Plus, it's usually easier to work with them when you lots of values you need to add to the command.

Glad you got it working.

-Peter