.Parameters.Clear() //This is to clear the parameters sqlCon.Close() sqlCon.Dispose() sqlCmd.Dispose()