[ASP.NET] How do you connect to a database?

[Izzmo]

I don't know what wrong, but I just don't get the process of connecting to a database in ASP.NET. It's soo dang confusing. The ironic part of it is, Microsoft said OleDB Connection was easy to use, *bullcrap*.

Anyways, does anyone know how to connect to a database using ASP.NET, and preferably C#, if not, VB is fine. And also, if applicable, how to do a query after connected?

Thanks,
~Izz

[Net-Margin]

http://www.google.co.uk/search?hl=en...ith+C%23&meta=

The top link has something to do with OleDB but i'm not sure if it's what you want, I have no clue with ASP.

[Izzmo]

It was a good try, but that is referring to MS Access databases

[reteep]

Fully depends on the database, if it's SQL Server you need to have a connection string in the web.config:

PHP Code:

<add name="LocalSqlServer" connectionString="data source=xx;initial catalog=xx;Integrated Security=SSPI;"/> 


then example:

PHP Code:

using System.Data.SqlClient;

System.Data.SqlClient.SqlConnection cn;
this.cn = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);

 SqlCommand cmd = new SqlCommand();
            SqlDataReader dr;

            cmd.Connection = this.cn;
            cmd.CommandText = "SELECT kwID FROM xx WHERE userID='" + this.UserID + "'";

            cn.Open();
            dr = cmd.ExecuteReader();

            dr.Read(); // We only need a single Read Run here cuz we want to get the oldest result ~
            kwID = dr["kwID"].ToString();
            dr.Close(); 


hth

[Izzmo]

Finally! Some light!

I'm reading this book: Learn ASP.NET in 21 Days! and I got stuck at the Database part because I couldn't figure out how to connect to my SQL server lol Everything in the book is MS Access.

Thanks reteep!