Connection to SQL

[David Lozzi]

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

Thanks,

--
David Lozzi
Web Applications/Network Specialist
Delphi Technology Solutions, Inc.
dlozzi(remove-this)@delphi-ts.com

[Kevin Spencer]

System.Data.SqlClient NameSpace.

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

"David Lozzi" <dlozzi(remove-this)@delphi-ts.com> wrote in message
news:uZ*************@TK2MSFTNGP12.phx.gbl...

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

Thanks,

--
David Lozzi
Web Applications/Network Specialist
Delphi Technology Solutions, Inc.
dlozzi(remove-this)@delphi-ts.com

[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" <dlozzi(remove-this)@delphi-ts.com> wrote in message
news:uZ*************@TK2MSFTNGP12.phx.gbl...

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

Thanks,

--
David Lozzi
Web Applications/Network Specialist
Delphi Technology Solutions, Inc.
dlozzi(remove-this)@delphi-ts.com

[David Lozzi]

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

--
David Lozzi
Web Applications/Network Specialist
Delphi Technology Solutions, Inc.
dlozzi(remove-this)@delphi-ts.com
"Kevin Spencer" <ks******@takempis.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

System.Data.SqlClient NameSpace.

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

"David Lozzi" <dlozzi(remove-this)@delphi-ts.com> wrote in message
news:uZ*************@TK2MSFTNGP12.phx.gbl...

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

Thanks,

--
David Lozzi
Web Applications/Network Specialist
Delphi Technology Solutions, Inc.
dlozzi(remove-this)@delphi-ts.com

[David Lozzi]

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

--
David Lozzi
Web Applications/Network Specialist
Delphi Technology Solutions, Inc.
dlozzi(remove-this)@delphi-ts.com
"Mark" <mf****@idonotlikespam.cce.umn.edu> wrote in message
news:uA**************@tk2msftngp13.phx.gbl...

//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" <dlozzi(remove-this)@delphi-ts.com> wrote in message
news:uZ*************@TK2MSFTNGP12.phx.gbl...

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

Thanks,

--
David Lozzi
Web Applications/Network Specialist
Delphi Technology Solutions, Inc.
dlozzi(remove-this)@delphi-ts.com

[David Lozzi]

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

--
David Lozzi
Web Applications/Network Specialist
Delphi Technology Solutions, Inc.
dlozzi(remove-this)@delphi-ts.com
"David Lozzi" <dlozzi(remove-this)@delphi-ts.com> wrote in message
news:O8*************@tk2msftngp13.phx.gbl...

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

--
David Lozzi
Web Applications/Network Specialist
Delphi Technology Solutions, Inc.
dlozzi(remove-this)@delphi-ts.com
"Mark" <mf****@idonotlikespam.cce.umn.edu> wrote in message
news:uA**************@tk2msftngp13.phx.gbl...

//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" <dlozzi(remove-this)@delphi-ts.com> wrote in message
news:uZ*************@TK2MSFTNGP12.phx.gbl...

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

Thanks,

--
David Lozzi
Web Applications/Network Specialist
Delphi Technology Solutions, Inc.
dlozzi(remove-this)@delphi-ts.com

[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
"David Lozzi" <dlozzi(remove-this)@delphi-ts.com> wrote in message
news:uW**************@tk2msftngp13.phx.gbl...

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

--
David Lozzi
Web Applications/Network Specialist
Delphi Technology Solutions, Inc.
dlozzi(remove-this)@delphi-ts.com
"David Lozzi" <dlozzi(remove-this)@delphi-ts.com> wrote in message
news:O8*************@tk2msftngp13.phx.gbl...

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

--
David Lozzi
Web Applications/Network Specialist
Delphi Technology Solutions, Inc.
dlozzi(remove-this)@delphi-ts.com
"Mark" <mf****@idonotlikespam.cce.umn.edu> wrote in message
news:uA**************@tk2msftngp13.phx.gbl...

//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" <dlozzi(remove-this)@delphi-ts.com> wrote in message
news:uZ*************@TK2MSFTNGP12.phx.gbl...
> What is the best way to connect to a SQL database from ASP.NET?
>
> Thanks,
>
> --
> David Lozzi
> Web Applications/Network Specialist
> Delphi Technology Solutions, Inc.
> dlozzi(remove-this)@delphi-ts.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/d...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" <dlozzi(remove-this)@delphi-ts.com> wrote in message
news:eP**************@tk2msftngp13.phx.gbl...

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

--
David Lozzi
Web Applications/Network Specialist
Delphi Technology Solutions, Inc.
dlozzi(remove-this)@delphi-ts.com
"Kevin Spencer" <ks******@takempis.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

System.Data.SqlClient NameSpace.

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

"David Lozzi" <dlozzi(remove-this)@delphi-ts.com> wrote in message
news:uZ*************@TK2MSFTNGP12.phx.gbl...

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

Thanks,

--
David Lozzi
Web Applications/Network Specialist
Delphi Technology Solutions, Inc.
dlozzi(remove-this)@delphi-ts.com

[David Lozzi]

OK, i think i found the solutions..

thanks,

--
David Lozzi
Web Applications/Network Specialist
Delphi Technology Solutions, Inc.
dlozzi(remove-this)@delphi-ts.com
"David Lozzi" <dlozzi(remove-this)@delphi-ts.com> wrote in message
news:uZ*************@TK2MSFTNGP12.phx.gbl...

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

Thanks,

--
David Lozzi
Web Applications/Network Specialist
Delphi Technology Solutions, Inc.
dlozzi(remove-this)@delphi-ts.com