Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using (SqlConnection con = new SqlConnection(cs))
- {
- string Query = "update DeviceDetails set GroupId = NULL, InUse = 0 , Status = 'Deleted' Where Id = @Id";
- using (SqlCommand cmd = new SqlCommand(Query, con))
- {
- try
- {
- con.Open();
- cmd.CommandType = CommandType.Text;
- cmd.Parameters.AddWithValue("@Id", SqlDbType.NVarChar);
- cmd.ExecuteNonQuery();
- }
- catch (Exception ex)
- {
- Response.Write(ex.Message);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement