Creating a Control that loads its data at runtime based on connection string property

[SteveL]

Hi,
I have created a custom control for editing a standard address.
This control contains combo boxes for County, Country etc

The control contains a property that is used at design time to specify a connection string. My intension is to populate the controls at runtime

What is the best approach to utilise this property? What event should i use to load the data?

Thanks for any help

 

[vis781]

So am i right in saying that you want to be able to populate the control and be able to change the connection string property at runtime then load the appropriate information based on the connection? am i on the right track here.

 

[SteveL]

I want to be able to point the control to a different sql server datasource at design time only.

Running the application that contains the control will populate the combo boxes within the control based on the connection string provided.

I intend to populate a dataset 'housed' within the control, this will provide the data for my combo boxes.

Thanks

 

[jmcilhinney]

So declare a private member variable of type SqlConnection and expose its ConnectionString property through a public property of the control.

 

[SteveL]

I want to set the property via the property grid without using any code.
Any ideas? I can add the property attribute to the control but im unsure how to reference it.
Thanks