connecting to database from script component

Can someone please send me some sample code on how to connect to the database from the script component? I tried using the connection manager to establish a connection and then use it inside my code in VB.NET but it did not work. Please send me some samples.did you try using ado.net to connect to the database?|||

See also http://msdn2.microsoft.com/en-us/library/ms135897.aspx

And here is a sample of destination component:
http://msdn2.microsoft.com/en-us/library/ms135939.aspx