D
David Lozzi
What is the best way to connect to a SQL database from ASP.NET?
Thanks,
Thanks,
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Kevin Spencer
System.Data.SqlClient NameSpace.
--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
M
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
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
D
David Lozzi
Could I have a little more information? Like an example or a MS reference?
D
David Lozzi
I get an error: Type 'SqlConnection' is not defined.
D
David Lozzi
If i put System.Data.SqlClient. infront of it, it works fine. How can I
'declare' this for the entire doc?
'declare' this for the entire doc?
M
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
top of your code-behind:
using System.Data;
using System.Data.SqlClient;
mark
www.dovetaildatabases.com
K
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.
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.
D
David Lozzi
OK, i think i found the solutions..
thanks,
thanks,