C# SQL UPDATE


SqlConnection conn;
string sqlIns;
SqlCommand cmdIns;
//-----
conn = new SqlConnection("Data Source=*****;Initial Catalog=*****;Integrated Security=True");
conn.Open();
sqlIns = "UPDATE [LAN_SNMP_TorF] SET [TorF]=@TorF WHERE [IP]=@ip";
try
{
cmdIns = new SqlCommand(sqlIns, conn);
cmdIns.Parameters.Add("@ip", "192.168.11.160");
cmdIns.Parameters.Add("@TorF", "F");
cmdIns.ExecuteNonQuery();

// Get the last inserted id.
cmdIns.Dispose();
cmdIns = null;
}
catch (Exception ex)
{
throw new Exception(ex.ToString(), ex);
}
finally
{
conn.Close();
}