[RESOLVED] What is Bound and unbound control?

[bp_forum]

Could any one please explain me what is Bound and unbound control in VB6?
pls give some example.

regards
balaram

[RhinoBull]

A bound control is control that is permanently bound (or connected) to a data source (data control).
To accomplish that you'd drop a data control control (note: there 2 types - dao and ado) on the form, configure its database connection, assign source (table, query, view...) and finally assign data control as a source for your control.
Otherwise everything needs to be done manually - a lot more coding but you gain a lot more flexibility.

[Hack]

a lot more coding but you gain a lot more flexibility.

And a lot more control...avoid bound controls.

[si_the_geek]

Bound controls are generally thought of as very bad, and you can find a fuller explanation of why in the article Why is using bound controls a bad thing? from our Database Development FAQs/Tutorials (at the top of this forum)

[bp_forum]

Thanks for your time to reply,
now I have bit idea of bound control.
One more thing; this mean If I need to connect to data base say "Oracle" then what we need to do? which option to use below
1. use ado control and place on form then set its parameters [as explain by you in #2]
2. manually write syntax in form load like CNN.Connect "Provider microsoft for oracle username ; scott Password=tiger ; database=orcl" {something like this}.
I generally use 2nd option.
could any one please help me is it a bad practice. or I am on the right track unfortunately.
is 2nd otiopn is unbound control.
Thanks
Balaram Prajapati

[Hack]

Option 2 is the way to go...you are on the correct track!

[bp_forum]

Thanks a lot for this,