0

I have a number of stored procedures. I used the .net server explorer and the dataset generator to create table adapter and table pairs.

Now in my code I want to dynamically instantiate these table adapters based on the user selecting a choice from a list (the report of their choice which corresponds to a stored procedure and table adapter).

The problem is I can't seem to instantiate the table adapter properly. The table works fine and when I do the table adapter, I can drill down on the properties at run time and even find and invoke the fill method, but when I try to set the connection string, I can't find it using getproperty. Does anyone have an example that works for how to do this? I've tried a few examples I found online, but nothing seems to work.

agezna
  • 133
  • 1
  • 3
  • 9

1 Answers1

0

Figured it out. When .Net creates the table adapter in the code behind for msDataSetGenerator, it declares the Connection property as Friend rather than Public. When I change it to Public, I can get and set it through Reflection like the other properties/methods that were declared public.

Having discovered this, I wonder if there really is a security risk in changing the get/set's for the connection string to public...

agezna
  • 133
  • 1
  • 3
  • 9