using (SqlConnection conn =new SqlConnection(connectionString))

using (SqlConnection conn =new SqlConnection(connectionString))
{
SqlCommand comm=new SqlCommand();
comm.Connection =conn;
comm.CommandType =CommandType.Text ;
comm.CommandText =sqlstr;
try
{
conn.Open();
i=comm.ExecuteNonQuery();
return i;
}
catch(SqlException e)
{
throw new Exception(e.Message);
}
finally
{
conn.Close();
comm.Dispose();
}
}

------------------

snigoal@Wang,HUST.Wuhan.China