Migrating Scripts Written Around Access To Sql.

Hey guys, I had purchased a program that generates full operational asp.net pages from an access db. I was unfamiliar with the language, and so that was the route I took. After disecting it and studying I've learned a bit and made it work in my environment. However, I now need to migrate everything over to mssql. I got the db portion down and now I'm trying to modify my scripts to point to a sql db rather than an access db. I thought it was going to be relatively simple but it's proving to be quite a challenge for me.

Was wondering if anyone could check my work.

 The original access driven page had the following connection strings.
vb page had [
public strConn as string="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & Server.MapPath("../") & "/db/db.mdb"
end class
]
and in my aspx. pages I had
AccessDataSourceControl1.selectcommand="SELECT * FROM table "
AccessDataSourceControl1.ConnectionString = strConn

 My new page now has the following.

I got rid of the .vb page and put this in.

Dim myConnection as New SqlConnection("Server=mysqlserver;Database=db;UID=myusername;PWD=my pw;")

Const strSQL as String ="SELECT * FROM table"

Dim myCommand as New SqlCommand(strSQL, myConnection)

 

further down I have a wmx data grid. I'm assuming I don't need to touch that but there is a line that has,


<wmx:AccessDataSourceControl id="AccessDataSourceControl1" runat="server" ></wmx:AccessDataSourceControl>

and I don't know what the equivilant of that is. I know its pointing to the accessdatasoucrcontrol1 that has the select command, but what would be the equivilant of
wmx:accessdatasourcecontrol?

Also, is this the way to go? by that i mean, should I just rescript everything?

Also,

1) Am I connecting to the sql db properly?
2) some sites say I have to put a connection string in the web.config file, is that true?
3) Does any one have any references I can goto, I'm having some trouble finding a good article that lays down exactly what needs to go where in an sql asp.net environment.

 Thanks guys.