Hello all,

This is just in reference to my previous post which was locked. My post was not meant to be offensive in any way and apologise to anyone that does see it this way. It was merely light humor with detriment to myself.

I am not naive to know if you bite the hand that feeds you you wont get fed.

Anyway. No offense meant.

No worries. In any case, how are you getting at the data? Datareader? Filling a dataset/datatable?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Hi again thanks for coming back. Ok page 1 sends id=? in the query string. Page 2 then looks for the data

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ListingDBConnectionString %>"
            SelectCommand="SELECT [ID], [CompName], [Add1], [Add2], [Add3], [Town], [City], [Postcode], [Tele], [Fax], [Website], [Email], [Package], [Description], [Logo] FROM [CompanyDetails] WHERE ([ID] = @ID)">
            <SelectParameters>
                <asp:QueryStringParameter Name="ID" QueryStringField="id" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>

Its then displayed in a Formview only I need to put some logic in to it so that it looks at the package value and renders the page accordingly. Hope this makes sense

By package value, I assume you mean the ID? How does the page render differ?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

ok page 1 sends a querystring id="something" page 2 then pulls the details for id="something" which also includes a column [Package] and the page then displays the various different bits of info depending on what the package level is

So if id=1 has a package of 4 more info will be displayed than if they had a package of 1

Hope thats clear now....not the best at describing properly