[2005] Data Tab Hlp Plz

[Jigabyte]

Hi Peeps,

Can someone tell me why I cannot see the oledbconnection and oledbdataset controls on my toolbar under data?

Thanks in advance,

Jiggy!

[kleinma]

Honestly, I don't think it is ever been in there, because its not really a toolbox component. They are almost always created via code.

You can put it there though if you want. Just right click on "data" in the toolbox and select "choose items". When the dialog comes up, you will see a textbox where you can filter the list. Type "ole" to get a list of the OLEDB classes you can add to the toolbox. Check the desired ones and click OK.

[kleinma]

oh, and there is no such thing as oledbdataset, but I think I know what you meant

[Jigabyte]

Thanks mate and your right I meant oledbDataAdapter, Doh!

[jmcilhinney]

In VS.NET 2003 (and 2002 I'd guess) those components (yes, they do inherit the Component class) were included in the Toolbox by default. From VS 2005 onwards they are not, basically because you'd rarely use them at design time anymore. If you want to create design-time data access components then you'd normally use the Data Source Wizard to generate a typed DataSet that would include TableAdapters. The TableAdapters take the place of the DataAdapter and Connection objects and they are automatically added to the Toolbox after the wizard completes.

If you don't want a typed DataSet then you'd normally not want to create your data access components in the designer. You can still create DataAdapters and Connections in code, just like any other objects. If you really do want to add a DataAdapter to a form in the designer then you can add the component to the toolbox manually, just as you can with any component.

[Jigabyte]

Cheers for that. I always do it in code but I am having a problem with component one truegrid so I wanted to go down this route.

Cheers again for the explanation.

Jiggy