в 15:30, 26 мая 2010

2010-05-26T15:30:57Z

Admin: 1 версия

2010-05-26T11:57:00Z

1 версия

Новая страница

== The using statement forces the connection to close, regardless of whether there is an error==



<source lang="csharp">
using statement also disposes of the Connection object.
If you need to reuse the Connection, then you need to reinitialize it.

SqlConnection con = new SqlConnection("Data Source=localhost;Integrated Security=True;Initial Catalog=Pubs");
SqlCommand cmd = new SqlCommand("INSERT Titles (Title) VALUES ("Some Title")", con);
using (con)
{
con.Open();
cmd.ExecuteNonQuery();
}</source>

== use a try...catch statement to force a connection to close==



<source lang="csharp">
SqlConnection con = new SqlConnection("Data Source=localhost;Integrated Security=True;Initial Catalog=Pubs");
SqlCommand cmd = new SqlCommand("INSERT Titles (Title) VALUES ("Some Title")", con);
try
{
con.Open();
cmd.ExecuteNonQuery();
}
finally
{
con.Close();
}</source>

← Предыдущая	Версия 15:30, 26 мая 2010
(нет различий)

ASP.NET Tutorial/ADO.net Database/using - История изменений

в 15:30, 26 мая 2010

Admin: 1 версия