Thanks for the reply. I got it now.

I don't know why but I originally only had the line:

<%@ Import Namespace="System.Data.SqlClient" %>

I added the one with the SqlDataAdapter after this line wasn't giving it to me to see if that would work. Now that I took the line out you told me I didn't need it shows up. No clue what I did differently.

I do have one question from the previous post. For someone who is fairly new to using vb code behind a web page. Is there some easy way to know what declarations I need? Or is there an easy way to tell or look up if something is an object of a class or a class that needs declaring?

Thanks for the info.

-Kim