.Net Compact Framework Questions Connect SQL Server

Using the VB .Net compact framework to develop windows CE applications. Brand new to this have done extensive work in VB 6 connecting to access and SQL alike but i cannot figure out a couple things with the compact framework.

1. I need a connection string that is made of the server, database, username, password, and provider from textboxes.. Would like to use a Adodb.Connection i am familiar with this.

2. Need to declare a recordset and then open using "Select * From Table Where Blah = 'Blah'", ConABC

Thanks in Advance Greg.