i am using vb 6.0 and oracle sql*plus ...........i need the code for ....when the car name is selected in the combo box it's corresponding purchase cost should be displayed in the text box..........and i have connected this to the database through ADODC connection
As a narrative, you should be putting code in the myComboBox_Click event to get the selected combo box item, then querying your Oracle database with the appropriate selection criteria to find the price you are looking for. Then use that returned value to set the myTextBox.Text value. Voila! Done.
I'm afraid that's the best I can offer, since I don't know your VB6 control names, or your Oracle database table names, or how you've populated your combo box, or the datatypes of your columns, blah, blah, blah. If what I've given you is enough, well then that's great. If not, post some code and maybe you'll get better help.
For Each ctrl As Control In Me.Controls("pnlMainPanel").Controls
If ctrl.GetType Is GetType(System.Windows.Forms.Panel) Then
For Each subCtrl As Control In ctrl.Controls
If subCtrl.GetType Is GetType(System.Windows.Forms.TextBox) Then
If subCtrl.GetType Is ...