Connection to SQL

[David Lozzi]

What is the best way to connect to a SQL database from ASP.NET?

Thanks,

 

[Kevin Spencer]

System.Data.SqlClient NameSpace.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

 

[Mark]

//This code inserts, updates or deletes a record(s) in a table using a
stored procedure with a single parameter.
//It would need to be modified for a Select statement that retrieved
records.

SqlConnection sqlConn = new SqlConnection("your connection string goes
here");
sqlConn.Open();
SqlCommand sqlComm = new SqlCommand("Your_stored_procedure_name", sqlConn);
SqlParameter prm1 = new SqlParameter("@my_prm",varchar,10);
prm1.value = "neat";
sqlComm.Parameters.Add(prm1);
sqlComm.CommandType = CommandType.StoredProcedure;
Int32 intNumberOfRecordsAffected = sqlComm.ExecuteNonQuery();
sqlConn.Close();

Hope this helps.

Mark
www.dovetaildatabases.com

 

[David Lozzi]

Could I have a little more information? Like an example or a MS reference?

 

[David Lozzi]

I get an error: Type 'SqlConnection' is not defined.

 

[David Lozzi]

If i put System.Data.SqlClient. infront of it, it works fine. How can I
'declare' this for the entire doc?

 

[Mark]

Assuming we're talking C# here, you can include the following line at the
top of your code-behind:

using System.Data;
using System.Data.SqlClient;

mark
www.dovetaildatabases.com

 

[Kevin Spencer]

Here is a link to the freely-downloadable and complete Microsoft .Net SDK,
which has plenty of references, articles, tutorials, and samples:

http://www.microsoft.com/downloads/...A6-3647-4070-9F41-A333C6B9181D&displaylang=en

That's the best I can give you without a more detailed request.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

 

[David Lozzi]

OK, i think i found the solutions..

thanks,