List box /combo box usage in a DTS VB custom task 
Author Message
 List box /combo box usage in a DTS VB custom task

I have requirement for a list box/combo box in a VB DTS custom Task. I
have implemented the populating of the list box in the Initialise and
the new method of the class but the values populated from Initialise
or New never appears. Later I replaced the list box by a combo which I
am populating in the combo_dropdown event even that does not work.
When I populate it to the combo on dropdown outside the DLL in a EXE
file it works but does not work with the custom task. Can any of you
please elaborate how to populate a listbox/combo in a VB DTS custom
task and once the user as selected a value how to persist the same.

Thanks
Simon



Thu, 16 Jun 2005 20:26:15 GMT
 List box /combo box usage in a DTS VB custom task

Have a look at this
http://www.mosaicinteractive.com/mitweb/software/customtasks.asp?Exam...

the persisting is done through the PersistPropertyBag

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


Quote:
> I have requirement for a list box/combo box in a VB DTS custom Task. I
> have implemented the populating of the list box in the Initialise and
> the new method of the class but the values populated from Initialise
> or New never appears. Later I replaced the list box by a combo which I
> am populating in the combo_dropdown event even that does not work.
> When I populate it to the combo on dropdown outside the DLL in a EXE
> file it works but does not work with the custom task. Can any of you
> please elaborate how to populate a listbox/combo in a VB DTS custom
> task and once the user as selected a value how to persist the same.

> Thanks
> Simon



Thu, 16 Jun 2005 22:31:57 GMT
 List box /combo box usage in a DTS VB custom task
Hi All

I still can't get the list box or combox box to work in a custom DTS
task. The text box, option button and check boxes work but the Combo
box/list box does not work. WOuld any of you take a simple example
like for a combo box - cmbTest which as the following 5 items:

Item 1
Item 2
Item 3
Item 4
Item 5

Can you please provide a small code snippet where do I add these items
into the combo box and once the user selects an option how do I store
that into the CustomUI property I have tried various things it just
does not work perhaps I am missing something can any of you please
provide the code snippets for the above simple example which class
event do I initialise the combo/list box and how do I store the value
selected by the user.

Your help is highly appreciated.

Thanks
Simon

Quote:

> Have a look at this
> http://www.mosaicinteractive.com/mitweb/software/customtasks.asp?Exam...

> the persisting is done through the PersistPropertyBag

> --

> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org



> > I have requirement for a list box/combo box in a VB DTS custom Task. I
> > have implemented the populating of the list box in the Initialise and
> > the new method of the class but the values populated from Initialise
> > or New never appears. Later I replaced the list box by a combo which I
> > am populating in the combo_dropdown event even that does not work.
> > When I populate it to the combo on dropdown outside the DLL in a EXE
> > file it works but does not work with the custom task. Can any of you
> > please elaborate how to populate a listbox/combo in a VB DTS custom
> > task and once the user as selected a value how to persist the same.

> > Thanks
> > Simon



Fri, 17 Jun 2005 21:45:20 GMT
 List box /combo box usage in a DTS VB custom task


Quote:
>I have requirement for a list box/combo box in a VB DTS custom Task. I
>have implemented the populating of the list box in the Initialise and
>the new method of the class but the values populated from Initialise
>or New never appears. Later I replaced the list box by a combo which I
>am populating in the combo_dropdown event even that does not work.
>When I populate it to the combo on dropdown outside the DLL in a EXE
>file it works but does not work with the custom task. Can any of you
>please elaborate how to populate a listbox/combo in a VB DTS custom
>task and once the user as selected a value how to persist the same.

>Thanks
>Simon

If the values in the box are static I would do this in the form load,
otherwise I always have a Public Property Set TaskObject(ByVal oNewTask
As DTS.Task). I pass through the current task and read the persisted
properties there, updating the UI as required.

Sample Custom Task Project
http://www.sqldts.com/default.aspx?6,107,284,0,0

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com



Fri, 17 Jun 2005 21:08:44 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Application Role w/Access 2000 combo boxes, list boxes, reports

2. List Box and Combo box

3. adding to a combo box or list box

4. pls help : COMBO box or list box

5. Vb 4.0 Problems updating Text Boxes from Combo Box linked to Data Control

6. Populating a combo box from another combo box

7. Populate a combo box from another combo box selection

8. selecting records for 2nd combo box dependant on first combo box

9. DTS Custom task in C# and threading model of DTS C# custom tasks

10. List/Combo box in VB

11. VB combo list box and Access Table

12. VB combo list box and Table database


 
Powered by phpBB® Forum Software