Microsoft Access: Using 2 SqlDataSource and 2 Repeaters in one page .NET v2

• quaxxon / 102 / Wed, 10 Feb 2010 16:51:00 GMT / Comments (0)
• Hello,

  I have 2 Repeaters in a page each using a different datasource. The problem is, is that they share the same querysting for getting data and Im getting conflics, because one WHERE clause uses Integer. To Correct this i did this on one of them

  <asp:QueryStringParameterName="ID"QueryStringField="id.ToString()"/>

  This now stops the error about converting a varChar value to int. All good I thought, but now no data will come out for this repeater because obviously the querysting is a number.

  For those who are wondering how i can have 2 repeaters and sharing the same QueryString, well its because i hide one of the repeaters if the QueryString value is Numeric. I also actually tried hiding the SqlDataSource aswell but this is not allowed.

  So my question is, How can i hide the connection and if i cant how could I get the repeater that uses the number value to work.

  Any ideas would be great!
• Keywords:

  sqldatasource, repeaters, page, .net, v2, microsoft, access, dotnet

• http://www.edevs.com/ms-access-database/256/«« Last Thread - Next Thread »»