Newbie Database Connection Question

[emblewembl]

Hi All, I have been working with Classic ASP for some time and am totally familiar with working with SQL databases etc,. But I am having trouble getting the basic info for connecting to an SQL database using ASP.Net. I have notcied some examples seem to have this at the top (or something similar) :

<%@ Import Namespace=&quot;System.Data.OleDb&quot; %>

Can someone explain to me what this is?!! Also, just to get started I am trying to build a page which connects to my SQL database so that I can write some of the information to the screen. Can anyone give me an example?
Thanks!! i love chocolate

 

[jfrost10]

I love chocolate too.

The import statement you mentioned is just saying that the class for your page should import the System.Data.OLEDB group of classes, which means you can use them.

However, if you're using SQL server, you probably don't want the OLEDB stuff. You'll want the System.Data.SqlClient namespace of classes to connect.

D'Arcy

 

[emblewembl]

Thanks JFrost10, not including the correct namespace file was the problem, and I have just connected without problems! i love chocolate